<!DOCTYPE html><html lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="viewport" content="width=device-width; initial-scale=1.0; maximum-scale=1.0; user-scalable=0;">
<meta charset="utf-8">
<title>PHPExcel classes » \PHPExcel_Worksheet</title>
<meta name="author" content="Mike van Riel">
<meta name="description" content="">
<link href="../css/template.css" rel="stylesheet" media="all">
<script src="../js/jquery-1.7.1.min.js" type="text/javascript"></script><script src="../js/jquery-ui-1.8.2.custom.min.js" type="text/javascript"></script><script src="../js/jquery.mousewheel.min.js" type="text/javascript"></script><script src="../js/bootstrap.js" type="text/javascript"></script><script src="../js/template.js" type="text/javascript"></script><script src="../js/prettify/prettify.min.js" type="text/javascript"></script><link rel="shortcut icon" href="../img/favicon.ico">
<link rel="apple-touch-icon" href="../img/apple-touch-icon.png">
<link rel="apple-touch-icon" sizes="72x72" href="../img/apple-touch-icon-72x72.png">
<link rel="apple-touch-icon" sizes="114x114" href="../img/apple-touch-icon-114x114.png">
</head>
<body>
<div class="navbar navbar-fixed-top">
<div class="navbar-inner"><div class="container">
<a class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse"><span class="icon-bar"></span><span class="icon-bar"></span><span class="icon-bar"></span></a><a class="brand" href="../index.html">PHPExcel classes</a><div class="nav-collapse"><ul class="nav">
<li class="dropdown">
<a href="#api" class="dropdown-toggle" data-toggle="dropdown">
                                    API Documentation <b class="caret"></b></a><ul class="dropdown-menu">
<li><a>Packages</a></li>
<li><a href="../packages/Default.html"><i class="icon-folder-open"></i> Default</a></li>
<li><a href="../packages/JAMA.html"><i class="icon-folder-open"></i> JAMA</a></li>
<li><a href="../packages/JAMA%0D%0ACholesky%20decomposition%20class%0D%0AFor%20a%20symmetric,%20positive%20definite%20matrix%20A,%20the%20Cholesky%20decomposition%0D%0Ais%20an%20lower%20triangular%20matrix%20L%20so%20that%20A%20=%20L*L'.html"><i class="icon-folder-open"></i> JAMA
Cholesky decomposition class
For a symmetric, positive definite matrix A, the Cholesky decomposition
is an lower triangular matrix L so that A = L*L'</a></li>
<li><a href="../packages/JAMA%0D%0AClass%20to%20obtain%20eigenvalues%20and%20eigenvectors%20of%20a%20real%20matrix.html"><i class="icon-folder-open"></i> JAMA
Class to obtain eigenvalues and eigenvectors of a real matrix</a></li>
<li><a href="../packages/JAMA%0D%0AError%20handling.html"><i class="icon-folder-open"></i> JAMA
Error handling</a></li>
<li><a href="../packages/JAMA%0D%0AFor%20an%20m-by-n%20matrix%20A%20with%20m%20&gt;=%20n,%20the%20LU%20decomposition%20is%20an%20m-by-n%0D%0Aunit%20lower%20triangular%20matrix%20L,%20an%20n-by-n%20upper%20triangular%20matrix%20U,%0D%0Aand%20a%20permutation%20vector%20piv%20of%20length%20m%20so%20that%20A(piv,:)%20=%20L*U.html"><i class="icon-folder-open"></i> JAMA
For an m-by-n matrix A with m &gt;= n, the LU decomposition is an m-by-n
unit lower triangular matrix L, an n-by-n upper triangular matrix U,
and a permutation vector piv of length m so that A(piv,:) = L*U</a></li>
<li><a href="../packages/JAMA%0D%0AFor%20an%20m-by-n%20matrix%20A%20with%20m%20&gt;=%20n,%20the%20QR%20decomposition%20is%20an%20m-by-n%0D%0Aorthogonal%20matrix%20Q%20and%20an%20n-by-n%20upper%20triangular%20matrix%20R%20so%20that%0D%0AA%20=%20Q*R.html"><i class="icon-folder-open"></i> JAMA
For an m-by-n matrix A with m &gt;= n, the QR decomposition is an m-by-n
orthogonal matrix Q and an n-by-n upper triangular matrix R so that
A = Q*R</a></li>
<li><a href="../packages/JAMA%0D%0AFor%20an%20m-by-n%20matrix%20A%20with%20m%20&gt;=%20n,%20the%20singular%20value%20decomposition%20is%0D%0Aan%20m-by-n%20orthogonal%20matrix%20U,%20an%20n-by-n%20diagonal%20matrix%20S,%20and%0D%0Aan%20n-by-n%20orthogonal%20matrix%20V%20so%20that%20A%20=%20U*S*V'.html"><i class="icon-folder-open"></i> JAMA
For an m-by-n matrix A with m &gt;= n, the singular value decomposition is
an m-by-n orthogonal matrix U, an n-by-n diagonal matrix S, and
an n-by-n orthogonal matrix V so that A = U*S*V'</a></li>
<li><a href="../packages/JAMA%0D%0APythagorean%20Theorem:%0D%0Aa%20=%203%0D%0Ab%20=%204%0D%0Ar%20=%20sqrt(square(a)%20+%20square(b))%0D%0Ar%20=%205%0D%0Ar%20=%20sqrt(a%5E2%20+%20b%5E2)%20without%20under.overflow.html"><i class="icon-folder-open"></i> JAMA
Pythagorean Theorem:
a = 3
b = 4
r = sqrt(square(a) + square(b))
r = 5
r = sqrt(a^2 + b^2) without under/overflow</a></li>
<li><a href="../packages/PHPExcel.html"><i class="icon-folder-open"></i> PHPExcel</a></li>
</ul>
</li>
<li class="dropdown" id="charts-menu">
<a href="#charts" class="dropdown-toggle" data-toggle="dropdown">
                                    Charts <b class="caret"></b></a><ul class="dropdown-menu"><li><a href="../graph_class.html"><i class="icon-list-alt"></i> Class hierarchy diagram</a></li></ul>
</li>
<li class="dropdown" id="reports-menu">
<a href="#reports" class="dropdown-toggle" data-toggle="dropdown">
                                    Reports <b class="caret"></b></a><ul class="dropdown-menu">
<li><a href="../errors.html"><i class="icon-remove-sign"></i> Errors 
                <span class="label label-info">551</span></a></li>
<li><a href="../markers.html"><i class="icon-map-marker"></i> Markers 
                <ul>
<li>todo 
                <span class="label label-info">19</span>
</li>
<li>fixme 
                <span class="label label-info">10</span>
</li>
</ul></a></li>
<li><a href="../deprecated.html"><i class="icon-stop"></i> Deprecated elements 
                <span class="label label-info">12</span></a></li>
</ul>
</li>
</ul></div>
</div></div>
<div class="go_to_top"><a href="#___" style="color: inherit">Back to top  <i class="icon-upload icon-white"></i></a></div>
</div>
<div id="___" class="container">
<noscript><div class="alert alert-warning">
                            Javascript is disabled; several features are only available
                            if Javascript is enabled.
                        </div></noscript>
<div class="row">
<div class="span4">
<span class="btn-group visibility" data-toggle="buttons-checkbox"><button class="btn public active" title="Show public elements">Public</button><button class="btn protected" title="Show protected elements">Protected</button><button class="btn private" title="Show private elements">Private</button><button class="btn inherited active" title="Show inherited elements">Inherited</button></span><div class="btn-group view pull-right" data-toggle="buttons-radio">
<button class="btn details" title="Show descriptions and method names"><i class="icon-list"></i></button><button class="btn simple" title="Show only method names"><i class="icon-align-justify"></i></button>
</div>
<ul class="side-nav nav nav-list">
<li class="nav-header">
<i class="icon-custom icon-method"></i> Methods
                    <ul>
<li class="method public "><a href="#method___clone" title="__clone :: Implement PHP __clone to create a deep clone, not just a shallow copy."><span class="description">Implement PHP __clone to create a deep clone, not just a shallow copy.</span><pre>__clone()</pre></a></li>
<li class="method public "><a href="#method___construct" title="__construct :: Create a new worksheet"><span class="description">Create a new worksheet</span><pre>__construct()</pre></a></li>
<li class="method public "><a href="#method___destruct" title="__destruct :: Code to execute when this worksheet is unset()"><span class="description">Code to execute when this worksheet is unset()</span><pre>__destruct()</pre></a></li>
<li class="method public "><a href="#method_addChart" title="addChart :: Add chart"><span class="description">Add chart</span><pre>addChart()</pre></a></li>
<li class="method public "><a href="#method_calculateColumnWidths" title="calculateColumnWidths :: Calculate widths for auto-size columns"><span class="description">Calculate widths for auto-size columns</span><pre>calculateColumnWidths()</pre></a></li>
<li class="method public "><a href="#method_calculateWorksheetDataDimension" title="calculateWorksheetDataDimension :: Calculate worksheet data dimension"><span class="description">Calculate worksheet data dimension</span><pre>calculateWorksheetDataDimension()</pre></a></li>
<li class="method public "><a href="#method_calculateWorksheetDimension" title="calculateWorksheetDimension :: Calculate worksheet dimension"><span class="description">Calculate worksheet dimension</span><pre>calculateWorksheetDimension()</pre></a></li>
<li class="method public "><a href="#method_cellExists" title="cellExists :: Does the cell at a specific coordinate exist?"><span class="description">Does the cell at a specific coordinate exist?</span><pre>cellExists()</pre></a></li>
<li class="method public "><a href="#method_cellExistsByColumnAndRow" title="cellExistsByColumnAndRow :: Cell at a specific coordinate by using numeric cell coordinates exists?"><span class="description">Cell at a specific coordinate by using numeric cell coordinates exists?</span><pre>cellExistsByColumnAndRow()</pre></a></li>
<li class="method public "><a href="#method_conditionalStylesExists" title="conditionalStylesExists :: Do conditional styles exist for this cell?"><span class="description">Do conditional styles exist for this cell?</span><pre>conditionalStylesExists()</pre></a></li>
<li class="method public "><a href="#method_copy" title="copy :: Copy worksheet (!= clone!)"><span class="description">Copy worksheet (!= clone!)</span><pre>copy()</pre></a></li>
<li class="method public "><a href="#method_dataValidationExists" title="dataValidationExists :: Data validation at a specific coordinate exists?"><span class="description">Data validation at a specific coordinate exists?</span><pre>dataValidationExists()</pre></a></li>
<li class="method public "><a href="#method_disconnectCells" title="disconnectCells :: Disconnect all cells from this PHPExcel_Worksheet object,
   typically so that the worksheet object can be unset"><span class="description">Disconnect all cells from this PHPExcel_Worksheet object,
   typically so that the worksheet object can be unset</span><pre>disconnectCells()</pre></a></li>
<li class="method public "><a href="#method_duplicateConditionalStyle" title="duplicateConditionalStyle :: Duplicate conditional style to a range of cells"><span class="description">Duplicate conditional style to a range of cells</span><pre>duplicateConditionalStyle()</pre></a></li>
<li class="method public "><a href="#method_duplicateStyle" title="duplicateStyle :: Duplicate cell style to a range of cells"><span class="description">Duplicate cell style to a range of cells</span><pre>duplicateStyle()</pre></a></li>
<li class="method public "><a href="#method_duplicateStyleArray" title="duplicateStyleArray :: Duplicate cell style array to a range of cells"><span class="description">Duplicate cell style array to a range of cells</span><pre>duplicateStyleArray()</pre></a></li>
<li class="method public "><a href="#method_extractSheetTitle" title="extractSheetTitle :: Extract worksheet title from range."><span class="description">Extract worksheet title from range.</span><pre>extractSheetTitle()</pre></a></li>
<li class="method public "><a href="#method_freezePane" title="freezePane :: Freeze Pane"><span class="description">Freeze Pane</span><pre>freezePane()</pre></a></li>
<li class="method public "><a href="#method_freezePaneByColumnAndRow" title="freezePaneByColumnAndRow :: Freeze Pane by using numeric cell coordinates"><span class="description">Freeze Pane by using numeric cell coordinates</span><pre>freezePaneByColumnAndRow()</pre></a></li>
<li class="method public "><a href="#method_fromArray" title="fromArray :: Fill worksheet from values in array"><span class="description">Fill worksheet from values in array</span><pre>fromArray()</pre></a></li>
<li class="method public "><a href="#method_garbageCollect" title="garbageCollect :: Run PHPExcel garabage collector."><span class="description">Run PHPExcel garabage collector.</span><pre>garbageCollect()</pre></a></li>
<li class="method public "><a href="#method_getActiveCell" title="getActiveCell :: Get active cell"><span class="description">Get active cell</span><pre>getActiveCell()</pre></a></li>
<li class="method public "><a href="#method_getAutoFilter" title="getAutoFilter :: Get Autofilter"><span class="description">Get Autofilter</span><pre>getAutoFilter()</pre></a></li>
<li class="method public "><a href="#method_getBreaks" title="getBreaks :: Get breaks"><span class="description">Get breaks</span><pre>getBreaks()</pre></a></li>
<li class="method public "><a href="#method_getCell" title="getCell :: Get cell at a specific coordinate"><span class="description">Get cell at a specific coordinate</span><pre>getCell()</pre></a></li>
<li class="method public "><a href="#method_getCellByColumnAndRow" title="getCellByColumnAndRow :: Get cell at a specific coordinate by using numeric cell coordinates"><span class="description">Get cell at a specific coordinate by using numeric cell coordinates</span><pre>getCellByColumnAndRow()</pre></a></li>
<li class="method public "><a href="#method_getCellCacheController" title="getCellCacheController :: Return the cache controller for the cell collection"><span class="description">Return the cache controller for the cell collection</span><pre>getCellCacheController()</pre></a></li>
<li class="method public "><a href="#method_getCellCollection" title="getCellCollection :: Get collection of cells"><span class="description">Get collection of cells</span><pre>getCellCollection()</pre></a></li>
<li class="method public "><a href="#method_getChartByIndex" title="getChartByIndex :: Get a chart by its index position"><span class="description">Get a chart by its index position</span><pre>getChartByIndex()</pre></a></li>
<li class="method public "><a href="#method_getChartByName" title="getChartByName :: Get a chart by name"><span class="description">Get a chart by name</span><pre>getChartByName()</pre></a></li>
<li class="method public "><a href="#method_getChartCollection" title="getChartCollection :: Get collection of charts"><span class="description">Get collection of charts</span><pre>getChartCollection()</pre></a></li>
<li class="method public "><a href="#method_getChartCount" title="getChartCount :: Return the count of charts on this worksheet"><span class="description">Return the count of charts on this worksheet</span><pre>getChartCount()</pre></a></li>
<li class="method public "><a href="#method_getChartNames" title="getChartNames :: Return an array of the names of charts on this worksheet"><span class="description">Return an array of the names of charts on this worksheet</span><pre>getChartNames()</pre></a></li>
<li class="method public "><a href="#method_getCodeName" title="getCodeName :: Return the code name of the sheet"><span class="description">Return the code name of the sheet</span><pre>getCodeName()</pre></a></li>
<li class="method public "><a href="#method_getColumnDimension" title="getColumnDimension :: Get column dimension at a specific column"><span class="description">Get column dimension at a specific column</span><pre>getColumnDimension()</pre></a></li>
<li class="method public "><a href="#method_getColumnDimensionByColumn" title="getColumnDimensionByColumn :: Get column dimension at a specific column by using numeric cell coordinates"><span class="description">Get column dimension at a specific column by using numeric cell coordinates</span><pre>getColumnDimensionByColumn()</pre></a></li>
<li class="method public "><a href="#method_getColumnDimensions" title="getColumnDimensions :: Get collection of column dimensions"><span class="description">Get collection of column dimensions</span><pre>getColumnDimensions()</pre></a></li>
<li class="method public "><a href="#method_getComment" title="getComment :: Get comment for cell"><span class="description">Get comment for cell</span><pre>getComment()</pre></a></li>
<li class="method public "><a href="#method_getCommentByColumnAndRow" title="getCommentByColumnAndRow :: Get comment for cell by using numeric cell coordinates"><span class="description">Get comment for cell by using numeric cell coordinates</span><pre>getCommentByColumnAndRow()</pre></a></li>
<li class="method public "><a href="#method_getComments" title="getComments :: Get comments"><span class="description">Get comments</span><pre>getComments()</pre></a></li>
<li class="method public "><a href="#method_getConditionalStyles" title="getConditionalStyles :: Get conditional styles for a cell"><span class="description">Get conditional styles for a cell</span><pre>getConditionalStyles()</pre></a></li>
<li class="method public "><a href="#method_getConditionalStylesCollection" title="getConditionalStylesCollection :: Get collection of conditional styles"><span class="description">Get collection of conditional styles</span><pre>getConditionalStylesCollection()</pre></a></li>
<li class="method public "><a href="#method_getDataValidation" title="getDataValidation :: Get data validation"><span class="description">Get data validation</span><pre>getDataValidation()</pre></a></li>
<li class="method public "><a href="#method_getDataValidationCollection" title="getDataValidationCollection :: Get collection of data validations"><span class="description">Get collection of data validations</span><pre>getDataValidationCollection()</pre></a></li>
<li class="method public "><a href="#method_getDefaultColumnDimension" title="getDefaultColumnDimension :: Get default column dimension"><span class="description">Get default column dimension</span><pre>getDefaultColumnDimension()</pre></a></li>
<li class="method public "><a href="#method_getDefaultRowDimension" title="getDefaultRowDimension :: Get default row dimension"><span class="description">Get default row dimension</span><pre>getDefaultRowDimension()</pre></a></li>
<li class="method public "><a href="#method_getDefaultStyle" title="getDefaultStyle :: Get default style of workbook."><span class="description">Get default style of workbook.</span><pre>getDefaultStyle()</pre></a></li>
<li class="method public "><a href="#method_getDrawingCollection" title="getDrawingCollection :: Get collection of drawings"><span class="description">Get collection of drawings</span><pre>getDrawingCollection()</pre></a></li>
<li class="method public "><a href="#method_getFreezePane" title="getFreezePane :: Get Freeze Pane"><span class="description">Get Freeze Pane</span><pre>getFreezePane()</pre></a></li>
<li class="method public "><a href="#method_getHashCode" title="getHashCode :: Get hash code"><span class="description">Get hash code</span><pre>getHashCode()</pre></a></li>
<li class="method public "><a href="#method_getHeaderFooter" title="getHeaderFooter :: Get page header/footer"><span class="description">Get page header/footer</span><pre>getHeaderFooter()</pre></a></li>
<li class="method public "><a href="#method_getHighestColumn" title="getHighestColumn :: Get highest worksheet column"><span class="description">Get highest worksheet column</span><pre>getHighestColumn()</pre></a></li>
<li class="method public "><a href="#method_getHighestDataColumn" title="getHighestDataColumn :: Get highest worksheet column that contains data"><span class="description">Get highest worksheet column that contains data</span><pre>getHighestDataColumn()</pre></a></li>
<li class="method public "><a href="#method_getHighestDataRow" title="getHighestDataRow :: Get highest worksheet row that contains data"><span class="description">Get highest worksheet row that contains data</span><pre>getHighestDataRow()</pre></a></li>
<li class="method public "><a href="#method_getHighestRow" title="getHighestRow :: Get highest worksheet row"><span class="description">Get highest worksheet row</span><pre>getHighestRow()</pre></a></li>
<li class="method public "><a href="#method_getHighestRowAndColumn" title="getHighestRowAndColumn :: Get highest worksheet column and highest row that have cell records"><span class="description">Get highest worksheet column and highest row that have cell records</span><pre>getHighestRowAndColumn()</pre></a></li>
<li class="method public "><a href="#method_getHyperlink" title="getHyperlink :: Get hyperlink"><span class="description">Get hyperlink</span><pre>getHyperlink()</pre></a></li>
<li class="method public "><a href="#method_getHyperlinkCollection" title="getHyperlinkCollection :: Get collection of hyperlinks"><span class="description">Get collection of hyperlinks</span><pre>getHyperlinkCollection()</pre></a></li>
<li class="method public "><a href="#method_getInvalidCharacters" title="getInvalidCharacters :: Get array of invalid characters for sheet title"><span class="description">Get array of invalid characters for sheet title</span><pre>getInvalidCharacters()</pre></a></li>
<li class="method public "><a href="#method_getMergeCells" title="getMergeCells :: Get merge cells array."><span class="description">Get merge cells array.</span><pre>getMergeCells()</pre></a></li>
<li class="method public "><a href="#method_getPageMargins" title="getPageMargins :: Get page margins"><span class="description">Get page margins</span><pre>getPageMargins()</pre></a></li>
<li class="method public "><a href="#method_getPageSetup" title="getPageSetup :: Get page setup"><span class="description">Get page setup</span><pre>getPageSetup()</pre></a></li>
<li class="method public "><a href="#method_getParent" title="getParent :: Get parent"><span class="description">Get parent</span><pre>getParent()</pre></a></li>
<li class="method public "><a href="#method_getPrintGridlines" title="getPrintGridlines :: Print gridlines?"><span class="description">Print gridlines?</span><pre>getPrintGridlines()</pre></a></li>
<li class="method public "><a href="#method_getProtectedCells" title="getProtectedCells :: Get protected cells"><span class="description">Get protected cells</span><pre>getProtectedCells()</pre></a></li>
<li class="method public "><a href="#method_getProtection" title="getProtection :: Get Protection"><span class="description">Get Protection</span><pre>getProtection()</pre></a></li>
<li class="method public "><a href="#method_getRightToLeft" title="getRightToLeft :: Get right-to-left"><span class="description">Get right-to-left</span><pre>getRightToLeft()</pre></a></li>
<li class="method public "><a href="#method_getRowDimension" title="getRowDimension :: Get row dimension at a specific row"><span class="description">Get row dimension at a specific row</span><pre>getRowDimension()</pre></a></li>
<li class="method public "><a href="#method_getRowDimensions" title="getRowDimensions :: Get collection of row dimensions"><span class="description">Get collection of row dimensions</span><pre>getRowDimensions()</pre></a></li>
<li class="method public "><a href="#method_getRowIterator" title="getRowIterator :: Get row iterator"><span class="description">Get row iterator</span><pre>getRowIterator()</pre></a></li>
<li class="method public "><a href="#method_getSelectedCell" title="getSelectedCell :: Get selected cell"><span class="description">Get selected cell</span><pre>getSelectedCell()</pre></a></li>
<li class="method public "><a href="#method_getSelectedCells" title="getSelectedCells :: Get selected cells"><span class="description">Get selected cells</span><pre>getSelectedCells()</pre></a></li>
<li class="method public "><a href="#method_getSheetState" title="getSheetState :: Get sheet state"><span class="description">Get sheet state</span><pre>getSheetState()</pre></a></li>
<li class="method public "><a href="#method_getSheetView" title="getSheetView :: Get sheet view"><span class="description">Get sheet view</span><pre>getSheetView()</pre></a></li>
<li class="method public "><a href="#method_getShowGridlines" title="getShowGridlines :: Show gridlines?"><span class="description">Show gridlines?</span><pre>getShowGridlines()</pre></a></li>
<li class="method public "><a href="#method_getShowRowColHeaders" title="getShowRowColHeaders :: Show row and column headers?"><span class="description">Show row and column headers?</span><pre>getShowRowColHeaders()</pre></a></li>
<li class="method public "><a href="#method_getShowSummaryBelow" title="getShowSummaryBelow :: Show summary below? (Row/Column outlining)"><span class="description">Show summary below? (Row/Column outlining)</span><pre>getShowSummaryBelow()</pre></a></li>
<li class="method public "><a href="#method_getShowSummaryRight" title="getShowSummaryRight :: Show summary right? (Row/Column outlining)"><span class="description">Show summary right? (Row/Column outlining)</span><pre>getShowSummaryRight()</pre></a></li>
<li class="method public "><a href="#method_getStyle" title="getStyle :: Get style for cell"><span class="description">Get style for cell</span><pre>getStyle()</pre></a></li>
<li class="method public "><a href="#method_getStyleByColumnAndRow" title="getStyleByColumnAndRow :: Get style for cell by using numeric cell coordinates"><span class="description">Get style for cell by using numeric cell coordinates</span><pre>getStyleByColumnAndRow()</pre></a></li>
<li class="method public "><a href="#method_getStyles" title="getStyles :: Get styles"><span class="description">Get styles</span><pre>getStyles()</pre></a></li>
<li class="method public "><a href="#method_getTabColor" title="getTabColor :: Get tab color"><span class="description">Get tab color</span><pre>getTabColor()</pre></a></li>
<li class="method public "><a href="#method_getTitle" title="getTitle :: Get title"><span class="description">Get title</span><pre>getTitle()</pre></a></li>
<li class="method public "><a href="#method_hasCodeName" title="hasCodeName :: Sheet has a code name ?"><span class="description">Sheet has a code name ?</span><pre>hasCodeName()</pre></a></li>
<li class="method public "><a href="#method_hyperlinkExists" title="hyperlinkExists :: Hyperlink at a specific coordinate exists?"><span class="description">Hyperlink at a specific coordinate exists?</span><pre>hyperlinkExists()</pre></a></li>
<li class="method public "><a href="#method_insertNewColumnBefore" title="insertNewColumnBefore :: Insert a new column, updating all possible related data"><span class="description">Insert a new column, updating all possible related data</span><pre>insertNewColumnBefore()</pre></a></li>
<li class="method public "><a href="#method_insertNewColumnBeforeByIndex" title="insertNewColumnBeforeByIndex :: Insert a new column, updating all possible related data"><span class="description">Insert a new column, updating all possible related data</span><pre>insertNewColumnBeforeByIndex()</pre></a></li>
<li class="method public "><a href="#method_insertNewRowBefore" title="insertNewRowBefore :: Insert a new row, updating all possible related data"><span class="description">Insert a new row, updating all possible related data</span><pre>insertNewRowBefore()</pre></a></li>
<li class="method public "><a href="#method_isTabColorSet" title="isTabColorSet :: Tab color set?"><span class="description">Tab color set?</span><pre>isTabColorSet()</pre></a></li>
<li class="method public "><a href="#method_mergeCells" title="mergeCells :: Set merge on a cell range"><span class="description">Set merge on a cell range</span><pre>mergeCells()</pre></a></li>
<li class="method public "><a href="#method_mergeCellsByColumnAndRow" title="mergeCellsByColumnAndRow :: Set merge on a cell range by using numeric cell coordinates"><span class="description">Set merge on a cell range by using numeric cell coordinates</span><pre>mergeCellsByColumnAndRow()</pre></a></li>
<li class="method public "><a href="#method_namedRangeToArray" title="namedRangeToArray :: Create array from a range of cells"><span class="description">Create array from a range of cells</span><pre>namedRangeToArray()</pre></a></li>
<li class="method public "><a href="#method_protectCells" title="protectCells :: Set protection on a cell range"><span class="description">Set protection on a cell range</span><pre>protectCells()</pre></a></li>
<li class="method public "><a href="#method_protectCellsByColumnAndRow" title="protectCellsByColumnAndRow :: Set protection on a cell range by using numeric cell coordinates"><span class="description">Set protection on a cell range by using numeric cell coordinates</span><pre>protectCellsByColumnAndRow()</pre></a></li>
<li class="method public "><a href="#method_rangeToArray" title="rangeToArray :: Create array from a range of cells"><span class="description">Create array from a range of cells</span><pre>rangeToArray()</pre></a></li>
<li class="method public "><a href="#method_rebindParent" title="rebindParent :: Re-bind parent"><span class="description">Re-bind parent</span><pre>rebindParent()</pre></a></li>
<li class="method public "><a href="#method_refreshColumnDimensions" title="refreshColumnDimensions :: Refresh column dimensions"><span class="description">Refresh column dimensions</span><pre>refreshColumnDimensions()</pre></a></li>
<li class="method public "><a href="#method_refreshRowDimensions" title="refreshRowDimensions :: Refresh row dimensions"><span class="description">Refresh row dimensions</span><pre>refreshRowDimensions()</pre></a></li>
<li class="method public "><a href="#method_removeAutoFilter" title="removeAutoFilter :: Remove autofilter"><span class="description">Remove autofilter</span><pre>removeAutoFilter()</pre></a></li>
<li class="method public "><a href="#method_removeColumn" title="removeColumn :: Remove a column, updating all possible related data"><span class="description">Remove a column, updating all possible related data</span><pre>removeColumn()</pre></a></li>
<li class="method public "><a href="#method_removeColumnByIndex" title="removeColumnByIndex :: Remove a column, updating all possible related data"><span class="description">Remove a column, updating all possible related data</span><pre>removeColumnByIndex()</pre></a></li>
<li class="method public "><a href="#method_removeConditionalStyles" title="removeConditionalStyles :: Removes conditional styles for a cell"><span class="description">Removes conditional styles for a cell</span><pre>removeConditionalStyles()</pre></a></li>
<li class="method public "><a href="#method_removeRow" title="removeRow :: Delete a row, updating all possible related data"><span class="description">Delete a row, updating all possible related data</span><pre>removeRow()</pre></a></li>
<li class="method public "><a href="#method_resetTabColor" title="resetTabColor :: Reset tab color"><span class="description">Reset tab color</span><pre>resetTabColor()</pre></a></li>
<li class="method public "><a href="#method_setAutoFilter" title="setAutoFilter :: Set AutoFilter"><span class="description">Set AutoFilter</span><pre>setAutoFilter()</pre></a></li>
<li class="method public "><a href="#method_setAutoFilterByColumnAndRow" title="setAutoFilterByColumnAndRow :: Set Autofilter Range by using numeric cell coordinates"><span class="description">Set Autofilter Range by using numeric cell coordinates</span><pre>setAutoFilterByColumnAndRow()</pre></a></li>
<li class="method public "><a href="#method_setBreak" title="setBreak :: Set break on a cell"><span class="description">Set break on a cell</span><pre>setBreak()</pre></a></li>
<li class="method public "><a href="#method_setBreakByColumnAndRow" title="setBreakByColumnAndRow :: Set break on a cell by using numeric cell coordinates"><span class="description">Set break on a cell by using numeric cell coordinates</span><pre>setBreakByColumnAndRow()</pre></a></li>
<li class="method public "><a href="#method_setCellValue" title="setCellValue :: Set a cell value"><span class="description">Set a cell value</span><pre>setCellValue()</pre></a></li>
<li class="method public "><a href="#method_setCellValueByColumnAndRow" title="setCellValueByColumnAndRow :: Set a cell value by using numeric cell coordinates"><span class="description">Set a cell value by using numeric cell coordinates</span><pre>setCellValueByColumnAndRow()</pre></a></li>
<li class="method public "><a href="#method_setCellValueExplicit" title="setCellValueExplicit :: Set a cell value"><span class="description">Set a cell value</span><pre>setCellValueExplicit()</pre></a></li>
<li class="method public "><a href="#method_setCellValueExplicitByColumnAndRow" title="setCellValueExplicitByColumnAndRow :: Set a cell value by using numeric cell coordinates"><span class="description">Set a cell value by using numeric cell coordinates</span><pre>setCellValueExplicitByColumnAndRow()</pre></a></li>
<li class="method public "><a href="#method_setCodeName" title="setCodeName :: Define the code name of the sheet"><span class="description">Define the code name of the sheet</span><pre>setCodeName()</pre></a></li>
<li class="method public "><a href="#method_setComments" title="setComments :: Set comments array for the entire sheet."><span class="description">Set comments array for the entire sheet.</span><pre>setComments()</pre></a></li>
<li class="method public "><a href="#method_setConditionalStyles" title="setConditionalStyles :: Set conditional styles"><span class="description">Set conditional styles</span><pre>setConditionalStyles()</pre></a></li>
<li class="method public "><a href="#method_setDataValidation" title="setDataValidation :: Set data validation"><span class="description">Set data validation</span><pre>setDataValidation()</pre></a></li>
<li class="method public "><a href="#method_setDefaultStyle" title="setDefaultStyle :: Set default style - should only be used by PHPExcel_IReader implementations!"><span class="description">Set default style - should only be used by PHPExcel_IReader implementations!</span><pre>setDefaultStyle()</pre></a></li>
<li class="method public "><a href="#method_setHeaderFooter" title="setHeaderFooter :: Set page header/footer"><span class="description">Set page header/footer</span><pre>setHeaderFooter()</pre></a></li>
<li class="method public "><a href="#method_setHyperlink" title="setHyperlink :: Set hyperlnk"><span class="description">Set hyperlnk</span><pre>setHyperlink()</pre></a></li>
<li class="method public "><a href="#method_setMergeCells" title="setMergeCells :: Set merge cells array for the entire sheet."><span class="description">Set merge cells array for the entire sheet.</span><pre>setMergeCells()</pre></a></li>
<li class="method public "><a href="#method_setPageMargins" title="setPageMargins :: Set page margins"><span class="description">Set page margins</span><pre>setPageMargins()</pre></a></li>
<li class="method public "><a href="#method_setPageSetup" title="setPageSetup :: Set page setup"><span class="description">Set page setup</span><pre>setPageSetup()</pre></a></li>
<li class="method public "><a href="#method_setPrintGridlines" title="setPrintGridlines :: Set print gridlines"><span class="description">Set print gridlines</span><pre>setPrintGridlines()</pre></a></li>
<li class="method public "><a href="#method_setProtection" title="setProtection :: Set Protection"><span class="description">Set Protection</span><pre>setProtection()</pre></a></li>
<li class="method public "><a href="#method_setRightToLeft" title="setRightToLeft :: Set right-to-left"><span class="description">Set right-to-left</span><pre>setRightToLeft()</pre></a></li>
<li class="method public "><a href="#method_setSelectedCell" title="setSelectedCell :: Selected cell"><span class="description">Selected cell</span><pre>setSelectedCell()</pre></a></li>
<li class="method public "><a href="#method_setSelectedCellByColumnAndRow" title="setSelectedCellByColumnAndRow :: Selected cell by using numeric cell coordinates"><span class="description">Selected cell by using numeric cell coordinates</span><pre>setSelectedCellByColumnAndRow()</pre></a></li>
<li class="method public "><a href="#method_setSelectedCells" title="setSelectedCells :: Select a range of cells."><span class="description">Select a range of cells.</span><pre>setSelectedCells()</pre></a></li>
<li class="method public "><a href="#method_setSharedStyle" title="setSharedStyle :: Set shared cell style to a range of cells"><span class="description">Set shared cell style to a range of cells</span><pre>setSharedStyle()</pre></a></li>
<li class="method public "><a href="#method_setSheetState" title="setSheetState :: Set sheet state"><span class="description">Set sheet state</span><pre>setSheetState()</pre></a></li>
<li class="method public "><a href="#method_setSheetView" title="setSheetView :: Set sheet view"><span class="description">Set sheet view</span><pre>setSheetView()</pre></a></li>
<li class="method public "><a href="#method_setShowGridlines" title="setShowGridlines :: Set show gridlines"><span class="description">Set show gridlines</span><pre>setShowGridlines()</pre></a></li>
<li class="method public "><a href="#method_setShowRowColHeaders" title="setShowRowColHeaders :: Set show row and column headers"><span class="description">Set show row and column headers</span><pre>setShowRowColHeaders()</pre></a></li>
<li class="method public "><a href="#method_setShowSummaryBelow" title="setShowSummaryBelow :: Set show summary below"><span class="description">Set show summary below</span><pre>setShowSummaryBelow()</pre></a></li>
<li class="method public "><a href="#method_setShowSummaryRight" title="setShowSummaryRight :: Set show summary right"><span class="description">Set show summary right</span><pre>setShowSummaryRight()</pre></a></li>
<li class="method public "><a href="#method_setTitle" title="setTitle :: Set title"><span class="description">Set title</span><pre>setTitle()</pre></a></li>
<li class="method public "><a href="#method_shrinkRangeToFit" title="shrinkRangeToFit :: Accepts a range, returning it as a range that falls within the current highest row and column of the worksheet"><span class="description">Accepts a range, returning it as a range that falls within the current highest row and column of the worksheet</span><pre>shrinkRangeToFit()</pre></a></li>
<li class="method public "><a href="#method_sortCellCollection" title="sortCellCollection :: Sort collection of cells"><span class="description">Sort collection of cells</span><pre>sortCellCollection()</pre></a></li>
<li class="method public "><a href="#method_toArray" title="toArray :: Create array from worksheet"><span class="description">Create array from worksheet</span><pre>toArray()</pre></a></li>
<li class="method public "><a href="#method_unfreezePane" title="unfreezePane :: Unfreeze Pane"><span class="description">Unfreeze Pane</span><pre>unfreezePane()</pre></a></li>
<li class="method public "><a href="#method_unmergeCells" title="unmergeCells :: Remove merge on a cell range"><span class="description">Remove merge on a cell range</span><pre>unmergeCells()</pre></a></li>
<li class="method public "><a href="#method_unmergeCellsByColumnAndRow" title="unmergeCellsByColumnAndRow :: Remove merge on a cell range by using numeric cell coordinates"><span class="description">Remove merge on a cell range by using numeric cell coordinates</span><pre>unmergeCellsByColumnAndRow()</pre></a></li>
<li class="method public "><a href="#method_unprotectCells" title="unprotectCells :: Remove protection on a cell range"><span class="description">Remove protection on a cell range</span><pre>unprotectCells()</pre></a></li>
<li class="method public "><a href="#method_unprotectCellsByColumnAndRow" title="unprotectCellsByColumnAndRow :: Remove protection on a cell range by using numeric cell coordinates"><span class="description">Remove protection on a cell range by using numeric cell coordinates</span><pre>unprotectCellsByColumnAndRow()</pre></a></li>
</ul>
</li>
<li class="nav-header private">» Private
                    <ul>
<li class="method private "><a href="#method__checkSheetCodeName" title="_checkSheetCodeName :: Check sheet code name for valid Excel syntax"><span class="description">Check sheet code name for valid Excel syntax</span><pre>_checkSheetCodeName()</pre></a></li>
<li class="method private "><a href="#method__checkSheetTitle" title="_checkSheetTitle :: Check sheet title for valid Excel syntax"><span class="description">Check sheet title for valid Excel syntax</span><pre>_checkSheetTitle()</pre></a></li>
<li class="method private "><a href="#method__createNewCell" title="_createNewCell :: Create a new cell at the specified coordinate"><span class="description">Create a new cell at the specified coordinate</span><pre>_createNewCell()</pre></a></li>
</ul>
</li>
<li class="nav-header">
<i class="icon-custom icon-property"></i> Properties
                    <ul></ul>
</li>
<li class="nav-header private">» Private
                    <ul>
<li class="property private "><a href="#property__activeCell" title="$_activeCell :: Active cell."><span class="description"></span><pre>$_activeCell</pre></a></li>
<li class="property private "><a href="#property__autoFilter" title="$_autoFilter :: Autofilter Range and selection"><span class="description"></span><pre>$_autoFilter</pre></a></li>
<li class="property private "><a href="#property__breaks" title="$_breaks :: Collection of breaks"><span class="description"></span><pre>$_breaks</pre></a></li>
<li class="property private "><a href="#property__cachedHighestColumn" title="$_cachedHighestColumn :: Cached highest column"><span class="description"></span><pre>$_cachedHighestColumn</pre></a></li>
<li class="property private "><a href="#property__cachedHighestRow" title="$_cachedHighestRow :: Cached highest row"><span class="description"></span><pre>$_cachedHighestRow</pre></a></li>
<li class="property private "><a href="#property__cellCollection" title="$_cellCollection :: Cacheable collection of cells"><span class="description"></span><pre>$_cellCollection</pre></a></li>
<li class="property private "><a href="#property__cellCollectionIsSorted" title="$_cellCollectionIsSorted :: Is the current cell collection sorted already?"><span class="description"></span><pre>$_cellCollectionIsSorted</pre></a></li>
<li class="property private "><a href="#property__chartCollection" title="$_chartCollection :: Collection of Chart objects"><span class="description"></span><pre>$_chartCollection</pre></a></li>
<li class="property private "><a href="#property__codeName" title="$_codeName :: CodeName"><span class="description"></span><pre>$_codeName</pre></a></li>
<li class="property private "><a href="#property__columnDimensions" title="$_columnDimensions :: Collection of column dimensions"><span class="description"></span><pre>$_columnDimensions</pre></a></li>
<li class="property private "><a href="#property__comments" title="$_comments :: Collection of comments"><span class="description"></span><pre>$_comments</pre></a></li>
<li class="property private "><a href="#property__conditionalStylesCollection" title="$_conditionalStylesCollection :: Conditional styles."><span class="description"></span><pre>$_conditionalStylesCollection</pre></a></li>
<li class="property private "><a href="#property__dataValidationCollection" title="$_dataValidationCollection :: Data validation objects."><span class="description"></span><pre>$_dataValidationCollection</pre></a></li>
<li class="property private "><a href="#property__defaultColumnDimension" title="$_defaultColumnDimension :: Default column dimension"><span class="description"></span><pre>$_defaultColumnDimension</pre></a></li>
<li class="property private "><a href="#property__defaultRowDimension" title="$_defaultRowDimension :: Default row dimension"><span class="description"></span><pre>$_defaultRowDimension</pre></a></li>
<li class="property private "><a href="#property__dirty" title="$_dirty :: Dirty flag"><span class="description"></span><pre>$_dirty</pre></a></li>
<li class="property private "><a href="#property__drawingCollection" title="$_drawingCollection :: Collection of drawings"><span class="description"></span><pre>$_drawingCollection</pre></a></li>
<li class="property private "><a href="#property__freezePane" title="$_freezePane :: Freeze pane"><span class="description"></span><pre>$_freezePane</pre></a></li>
<li class="property private "><a href="#property__hash" title="$_hash :: Hash"><span class="description"></span><pre>$_hash</pre></a></li>
<li class="property private "><a href="#property__headerFooter" title="$_headerFooter :: Page header/footer"><span class="description"></span><pre>$_headerFooter</pre></a></li>
<li class="property private "><a href="#property__hyperlinkCollection" title="$_hyperlinkCollection :: Hyperlinks."><span class="description"></span><pre>$_hyperlinkCollection</pre></a></li>
<li class="property private "><a href="#property__invalidCharacters" title="$_invalidCharacters :: Invalid characters in sheet title"><span class="description"></span><pre>$_invalidCharacters</pre></a></li>
<li class="property private "><a href="#property__mergeCells" title="$_mergeCells :: Collection of merged cell ranges"><span class="description"></span><pre>$_mergeCells</pre></a></li>
<li class="property private "><a href="#property__pageMargins" title="$_pageMargins :: Page margins"><span class="description"></span><pre>$_pageMargins</pre></a></li>
<li class="property private "><a href="#property__pageSetup" title="$_pageSetup :: Page setup"><span class="description"></span><pre>$_pageSetup</pre></a></li>
<li class="property private "><a href="#property__parent" title="$_parent :: Parent spreadsheet"><span class="description"></span><pre>$_parent</pre></a></li>
<li class="property private "><a href="#property__printGridlines" title="$_printGridlines :: Print gridlines?"><span class="description"></span><pre>$_printGridlines</pre></a></li>
<li class="property private "><a href="#property__protectedCells" title="$_protectedCells :: Collection of protected cell ranges"><span class="description"></span><pre>$_protectedCells</pre></a></li>
<li class="property private "><a href="#property__protection" title="$_protection :: Protection"><span class="description"></span><pre>$_protection</pre></a></li>
<li class="property private "><a href="#property__rightToLeft" title="$_rightToLeft :: Right-to-left?"><span class="description"></span><pre>$_rightToLeft</pre></a></li>
<li class="property private "><a href="#property__rowDimensions" title="$_rowDimensions :: Collection of row dimensions"><span class="description"></span><pre>$_rowDimensions</pre></a></li>
<li class="property private "><a href="#property__selectedCells" title="$_selectedCells :: Selected cells"><span class="description"></span><pre>$_selectedCells</pre></a></li>
<li class="property private "><a href="#property__sheetState" title="$_sheetState :: Sheet state"><span class="description"></span><pre>$_sheetState</pre></a></li>
<li class="property private "><a href="#property__sheetView" title="$_sheetView :: Sheet view"><span class="description"></span><pre>$_sheetView</pre></a></li>
<li class="property private "><a href="#property__showGridlines" title="$_showGridlines :: Show gridlines?"><span class="description"></span><pre>$_showGridlines</pre></a></li>
<li class="property private "><a href="#property__showRowColHeaders" title="$_showRowColHeaders :: Show row and column headers?"><span class="description"></span><pre>$_showRowColHeaders</pre></a></li>
<li class="property private "><a href="#property__showSummaryBelow" title="$_showSummaryBelow :: Show summary below? (Row/Column outline)"><span class="description"></span><pre>$_showSummaryBelow</pre></a></li>
<li class="property private "><a href="#property__showSummaryRight" title="$_showSummaryRight :: Show summary right? (Row/Column outline)"><span class="description"></span><pre>$_showSummaryRight</pre></a></li>
<li class="property private "><a href="#property__styles" title="$_styles :: Collection of styles"><span class="description"></span><pre>$_styles</pre></a></li>
<li class="property private "><a href="#property__tabColor" title="$_tabColor :: Tab color"><span class="description"></span><pre>$_tabColor</pre></a></li>
<li class="property private "><a href="#property__title" title="$_title :: Worksheet title"><span class="description"></span><pre>$_title</pre></a></li>
</ul>
</li>
<li class="nav-header">
<i class="icon-custom icon-constant"></i> Constants
                    <ul>
<li class="constant  "><a href="#constant_BREAK_COLUMN" title="BREAK_COLUMN :: "><span class="description">BREAK_COLUMN</span><pre>BREAK_COLUMN</pre></a></li>
<li class="constant  "><a href="#constant_BREAK_NONE" title="BREAK_NONE :: "><span class="description">BREAK_NONE</span><pre>BREAK_NONE</pre></a></li>
<li class="constant  "><a href="#constant_BREAK_ROW" title="BREAK_ROW :: "><span class="description">BREAK_ROW</span><pre>BREAK_ROW</pre></a></li>
<li class="constant  "><a href="#constant_SHEETSTATE_HIDDEN" title="SHEETSTATE_HIDDEN :: "><span class="description">SHEETSTATE_HIDDEN</span><pre>SHEETSTATE_HIDDEN</pre></a></li>
<li class="constant  "><a href="#constant_SHEETSTATE_VERYHIDDEN" title="SHEETSTATE_VERYHIDDEN :: "><span class="description">SHEETSTATE_VERYHIDDEN</span><pre>SHEETSTATE_VERYHIDDEN</pre></a></li>
<li class="constant  "><a href="#constant_SHEETSTATE_VISIBLE" title="SHEETSTATE_VISIBLE :: "><span class="description">SHEETSTATE_VISIBLE</span><pre>SHEETSTATE_VISIBLE</pre></a></li>
</ul>
</li>
</ul>
</div>
<div class="span8">
<a id="\PHPExcel_Worksheet"></a><ul class="breadcrumb">
<li>
<a href="../index.html"><i class="icon-custom icon-class"></i></a><span class="divider">\</span>
</li>
<li><a href="../namespaces/global.html">global</a></li>
<li class="active">
<span class="divider">\</span><a href="../classes/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a>
</li>
</ul>
<div class="element class">
<p class="short_description">PHPExcel_Worksheet</p>
<div class="details">
<div class="long_description"></div>
<table class="table table-bordered">
<tr>
<th>category</th>
<td>PHPExcel</td>
</tr>
<tr>
<th>package</th>
<td><a href="../packages/PHPExcel.Worksheet.html">PHPExcel_Worksheet</a></td>
</tr>
<tr>
<th>copyright</th>
<td>Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)</td>
</tr>
</table>
<h3>
<i class="icon-custom icon-method"></i> Methods</h3>
<a id="method___clone"></a><div class="element clickable method public method___clone" data-toggle="collapse" data-target=".method___clone .collapse">
<h2>Implement PHP __clone to create a deep clone, not just a shallow copy.</h2>
<pre>__clone() </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="method___construct"></a><div class="element clickable method public method___construct" data-toggle="collapse" data-target=".method___construct .collapse">
<h2>Create a new worksheet</h2>
<pre>__construct(\PHPExcel $pParent, string $pTitle) </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pParent</h4>
<code><a href="../classes/PHPExcel.html">\PHPExcel</a></code>
</div>
<div class="subelement argument">
<h4>$pTitle</h4>
<code>string</code>
</div>
</div></div>
</div>
<a id="method___destruct"></a><div class="element clickable method public method___destruct" data-toggle="collapse" data-target=".method___destruct .collapse">
<h2>Code to execute when this worksheet is unset()</h2>
<pre>__destruct() </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="method_addChart"></a><div class="element clickable method public method_addChart" data-toggle="collapse" data-target=".method_addChart .collapse">
<h2>Add chart</h2>
<pre>addChart(\PHPExcel_Chart $pChart, int | null $iChartIndex) : <a href="../classes/PHPExcel_Chart.html">\PHPExcel_Chart</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pChart</h4>
<code><a href="../classes/PHPExcel_Chart.html">\PHPExcel_Chart</a></code>
</div>
<div class="subelement argument">
<h4>$iChartIndex</h4>
<code>int</code><code>null</code><p>Index where chart should go (0,1,..., or null for last)</p>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Chart.html">\PHPExcel_Chart</a></code></div>
</div></div>
</div>
<a id="method_calculateColumnWidths"></a><div class="element clickable method public method_calculateColumnWidths" data-toggle="collapse" data-target=".method_calculateColumnWidths .collapse">
<h2>Calculate widths for auto-size columns</h2>
<pre>calculateColumnWidths(boolean $calculateMergeCells) : \PHPExcel_Worksheet;</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$calculateMergeCells</h4>
<code>boolean</code><p>Calculate merge cell width</p></div>
<h3>Returns</h3>
<div class="subelement response"><code>\PHPExcel_Worksheet;</code></div>
</div></div>
</div>
<a id="method_calculateWorksheetDataDimension"></a><div class="element clickable method public method_calculateWorksheetDataDimension" data-toggle="collapse" data-target=".method_calculateWorksheetDataDimension .collapse">
<h2>Calculate worksheet data dimension</h2>
<pre>calculateWorksheetDataDimension() : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response">
<code>string</code>String containing the dimension of this worksheet that actually contain data</div>
</div></div>
</div>
<a id="method_calculateWorksheetDimension"></a><div class="element clickable method public method_calculateWorksheetDimension" data-toggle="collapse" data-target=".method_calculateWorksheetDimension .collapse">
<h2>Calculate worksheet dimension</h2>
<pre>calculateWorksheetDimension() : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response">
<code>string</code>String containing the dimension of this worksheet</div>
</div></div>
</div>
<a id="method_cellExists"></a><div class="element clickable method public method_cellExists" data-toggle="collapse" data-target=".method_cellExists .collapse">
<h2>Does the cell at a specific coordinate exist?</h2>
<pre>cellExists(string $pCoordinate) : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCoordinate</h4>
<code>string</code><p>Coordinate of the cell</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code>boolean</code></div>
</div></div>
</div>
<a id="method_cellExistsByColumnAndRow"></a><div class="element clickable method public method_cellExistsByColumnAndRow" data-toggle="collapse" data-target=".method_cellExistsByColumnAndRow .collapse">
<h2>Cell at a specific coordinate by using numeric cell coordinates exists?</h2>
<pre>cellExistsByColumnAndRow(string $pColumn, string $pRow) : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pColumn</h4>
<code>string</code><p>Numeric column coordinate of the cell</p></div>
<div class="subelement argument">
<h4>$pRow</h4>
<code>string</code><p>Numeric row coordinate of the cell</p></div>
<h3>Returns</h3>
<div class="subelement response"><code>boolean</code></div>
</div></div>
</div>
<a id="method_conditionalStylesExists"></a><div class="element clickable method public method_conditionalStylesExists" data-toggle="collapse" data-target=".method_conditionalStylesExists .collapse">
<h2>Do conditional styles exist for this cell?</h2>
<pre>conditionalStylesExists(string $pCoordinate) : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCoordinate</h4>
<code>string</code>
</div>
<h3>Returns</h3>
<div class="subelement response"><code>boolean</code></div>
</div></div>
</div>
<a id="method_copy"></a><div class="element clickable method public method_copy" data-toggle="collapse" data-target=".method_copy .collapse">
<h2>Copy worksheet (!= clone!)</h2>
<pre>copy() : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_dataValidationExists"></a><div class="element clickable method public method_dataValidationExists" data-toggle="collapse" data-target=".method_dataValidationExists .collapse">
<h2>Data validation at a specific coordinate exists?</h2>
<pre>dataValidationExists(string $pCoordinate) : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCoordinate</h4>
<code>string</code>
</div>
<h3>Returns</h3>
<div class="subelement response"><code>boolean</code></div>
</div></div>
</div>
<a id="method_disconnectCells"></a><div class="element clickable method public method_disconnectCells" data-toggle="collapse" data-target=".method_disconnectCells .collapse">
<h2>Disconnect all cells from this PHPExcel_Worksheet object,
   typically so that the worksheet object can be unset</h2>
<pre>disconnectCells() </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="method_duplicateConditionalStyle"></a><div class="element clickable method public method_duplicateConditionalStyle" data-toggle="collapse" data-target=".method_duplicateConditionalStyle .collapse">
<h2>Duplicate conditional style to a range of cells</h2>
<pre>duplicateConditionalStyle(array $pCellStyle, string $pRange) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"><p>Please note that this will overwrite existing cell styles for cells in range!</p></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCellStyle</h4>
<code>array</code><p>of PHPExcel_Style_Conditional   $pCellStyle Cell style to duplicate</p>
</div>
<div class="subelement argument">
<h4>$pRange</h4>
<code>string</code><p>Range of cells (i.e. "A1:B10"), or just one cell (i.e. "A1")</p>
</div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_duplicateStyle"></a><div class="element clickable method public method_duplicateStyle" data-toggle="collapse" data-target=".method_duplicateStyle .collapse">
<h2>Duplicate cell style to a range of cells</h2>
<pre>duplicateStyle(\PHPExcel_Style $pCellStyle, string $pRange) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"><p>Please note that this will overwrite existing cell styles for cells in range!</p></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCellStyle</h4>
<code><a href="../classes/PHPExcel_Style.html">\PHPExcel_Style</a></code><p>Cell style to duplicate</p></div>
<div class="subelement argument">
<h4>$pRange</h4>
<code>string</code><p>Range of cells (i.e. "A1:B10"), or just one cell (i.e. "A1")</p>
</div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_duplicateStyleArray"></a><div class="element clickable method public method_duplicateStyleArray" data-toggle="collapse" data-target=".method_duplicateStyleArray .collapse">
<h2>Duplicate cell style array to a range of cells</h2>
<pre>duplicateStyleArray(array $pStyles, string $pRange, boolean $pAdvanced) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"><p>Please note that this will overwrite existing cell styles for cells in range,
if they are in the styles array. For example, if you decide to set a range of
cells to font bold, only include font bold in the styles array.</p></div>
<table class="table table-bordered"><tr>
<th>deprecated</th>
<td></td>
</tr></table>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pStyles</h4>
<code>array</code><p>Array containing style information</p></div>
<div class="subelement argument">
<h4>$pRange</h4>
<code>string</code><p>Range of cells (i.e. "A1:B10"), or just one cell (i.e. "A1")</p>
</div>
<div class="subelement argument">
<h4>$pAdvanced</h4>
<code>boolean</code><p>Advanced mode for setting borders.</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_extractSheetTitle"></a><div class="element clickable method public method_extractSheetTitle" data-toggle="collapse" data-target=".method_extractSheetTitle .collapse">
<h2>Extract worksheet title from range.</h2>
<pre>extractSheetTitle(string $pRange, bool $returnRange) : mixed</pre>
<div class="labels"><span class="label">Static</span></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"><p>Example: extractSheetTitle("testSheet!A1") ==> 'A1'
Example: extractSheetTitle("'testSheet 1'!A1", true) ==> array('testSheet 1', 'A1');</p></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pRange</h4>
<code>string</code><p>Range to extract title from</p></div>
<div class="subelement argument">
<h4>$returnRange</h4>
<code>bool</code><p>Return range? (see example)</p>
</div>
<h3>Returns</h3>
<div class="subelement response"><code>mixed</code></div>
</div></div>
</div>
<a id="method_freezePane"></a><div class="element clickable method public method_freezePane" data-toggle="collapse" data-target=".method_freezePane .collapse">
<h2>Freeze Pane</h2>
<pre>freezePane(string $pCell) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCell</h4>
<code>string</code><p>Cell (i.e. A2)
                                   Examples:
                                       A2 will freeze the rows above cell A2 (i.e row 1)
                                       B1 will freeze the columns to the left of cell B1 (i.e column A)
                                       B2 will freeze the rows above and to the left of cell A2
                                           (i.e row 1 and column A)</p>
</div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_freezePaneByColumnAndRow"></a><div class="element clickable method public method_freezePaneByColumnAndRow" data-toggle="collapse" data-target=".method_freezePaneByColumnAndRow .collapse">
<h2>Freeze Pane by using numeric cell coordinates</h2>
<pre>freezePaneByColumnAndRow(int $pColumn, int $pRow) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pColumn</h4>
<code>int</code><p>Numeric column coordinate of the cell</p></div>
<div class="subelement argument">
<h4>$pRow</h4>
<code>int</code><p>Numeric row coordinate of the cell</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_fromArray"></a><div class="element clickable method public method_fromArray" data-toggle="collapse" data-target=".method_fromArray .collapse">
<h2>Fill worksheet from values in array</h2>
<pre>fromArray(array $source, mixed $nullValue, string $startCell, boolean $strictNullComparison) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$source</h4>
<code>array</code><p>Source array</p></div>
<div class="subelement argument">
<h4>$nullValue</h4>
<code>mixed</code><p>Value in source array that stands for blank cell</p></div>
<div class="subelement argument">
<h4>$startCell</h4>
<code>string</code><p>Insert array starting from this cell address as the top left coordinate</p></div>
<div class="subelement argument">
<h4>$strictNullComparison</h4>
<code>boolean</code><p>Apply strict comparison when testing for null values in the array</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_garbageCollect"></a><div class="element clickable method public method_garbageCollect" data-toggle="collapse" data-target=".method_garbageCollect .collapse">
<h2>Run PHPExcel garabage collector.</h2>
<pre>garbageCollect() : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_getActiveCell"></a><div class="element clickable method public method_getActiveCell" data-toggle="collapse" data-target=".method_getActiveCell .collapse">
<h2>Get active cell</h2>
<pre>getActiveCell() : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response">
<code>string</code>Example: 'A1'</div>
</div></div>
</div>
<a id="method_getAutoFilter"></a><div class="element clickable method public method_getAutoFilter" data-toggle="collapse" data-target=".method_getAutoFilter .collapse">
<h2>Get Autofilter</h2>
<pre>getAutoFilter() </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"><p>@return PHPExcel_Worksheet_AutoFilter</p></div></div></div>
</div>
<a id="method_getBreaks"></a><div class="element clickable method public method_getBreaks" data-toggle="collapse" data-target=".method_getBreaks .collapse">
<h2>Get breaks</h2>
<pre>getBreaks() : array[]</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code>array[]</code></div>
</div></div>
</div>
<a id="method_getCell"></a><div class="element clickable method public method_getCell" data-toggle="collapse" data-target=".method_getCell .collapse">
<h2>Get cell at a specific coordinate</h2>
<pre>getCell(string $pCoordinate) : <a href="../classes/PHPExcel_Cell.html">\PHPExcel_Cell</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCoordinate</h4>
<code>string</code><p>Coordinate of the cell</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response">
<code><a href="../classes/PHPExcel_Cell.html">\PHPExcel_Cell</a></code>Cell that was found</div>
</div></div>
</div>
<a id="method_getCellByColumnAndRow"></a><div class="element clickable method public method_getCellByColumnAndRow" data-toggle="collapse" data-target=".method_getCellByColumnAndRow .collapse">
<h2>Get cell at a specific coordinate by using numeric cell coordinates</h2>
<pre>getCellByColumnAndRow(string $pColumn, string $pRow) : <a href="../classes/PHPExcel_Cell.html">\PHPExcel_Cell</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pColumn</h4>
<code>string</code><p>Numeric column coordinate of the cell</p></div>
<div class="subelement argument">
<h4>$pRow</h4>
<code>string</code><p>Numeric row coordinate of the cell</p></div>
<h3>Returns</h3>
<div class="subelement response">
<code><a href="../classes/PHPExcel_Cell.html">\PHPExcel_Cell</a></code>Cell that was found</div>
</div></div>
</div>
<a id="method_getCellCacheController"></a><div class="element clickable method public method_getCellCacheController" data-toggle="collapse" data-target=".method_getCellCacheController .collapse">
<h2>Return the cache controller for the cell collection</h2>
<pre>getCellCacheController() : \PHPExcel_CachedObjectStorage_xxx</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code>\PHPExcel_CachedObjectStorage_xxx</code></div>
</div></div>
</div>
<a id="method_getCellCollection"></a><div class="element clickable method public method_getCellCollection" data-toggle="collapse" data-target=".method_getCellCollection .collapse">
<h2>Get collection of cells</h2>
<pre>getCellCollection(boolean $pSorted) : <a href="PHPExcel.Cell.html#%5CPHPExcel_Cell">\PHPExcel_Cell[]</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pSorted</h4>
<code>boolean</code><p>Also sort the cell collection?</p>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="PHPExcel.Cell.html#%5CPHPExcel_Cell">\PHPExcel_Cell[]</a></code></div>
</div></div>
</div>
<a id="method_getChartByIndex"></a><div class="element clickable method public method_getChartByIndex" data-toggle="collapse" data-target=".method_getChartByIndex .collapse">
<h2>Get a chart by its index position</h2>
<pre>getChartByIndex(string $index) : false | <a href="../classes/PHPExcel_Chart.html">\PHPExcel_Chart</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$index</h4>
<code>string</code><p>Chart index position</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response">
<code>false</code><code><a href="../classes/PHPExcel_Chart.html">\PHPExcel_Chart</a></code>
</div>
</div></div>
</div>
<a id="method_getChartByName"></a><div class="element clickable method public method_getChartByName" data-toggle="collapse" data-target=".method_getChartByName .collapse">
<h2>Get a chart by name</h2>
<pre>getChartByName(string $chartName) : false | <a href="../classes/PHPExcel_Chart.html">\PHPExcel_Chart</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$chartName</h4>
<code>string</code><p>Chart name</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response">
<code>false</code><code><a href="../classes/PHPExcel_Chart.html">\PHPExcel_Chart</a></code>
</div>
</div></div>
</div>
<a id="method_getChartCollection"></a><div class="element clickable method public method_getChartCollection" data-toggle="collapse" data-target=".method_getChartCollection .collapse">
<h2>Get collection of charts</h2>
<pre>getChartCollection() : <a href="PHPExcel.Chart.html#%5CPHPExcel_Chart">\PHPExcel_Chart[]</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="PHPExcel.Chart.html#%5CPHPExcel_Chart">\PHPExcel_Chart[]</a></code></div>
</div></div>
</div>
<a id="method_getChartCount"></a><div class="element clickable method public method_getChartCount" data-toggle="collapse" data-target=".method_getChartCount .collapse">
<h2>Return the count of charts on this worksheet</h2>
<pre>getChartCount() : int</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response">
<code>int</code>The number of charts</div>
</div></div>
</div>
<a id="method_getChartNames"></a><div class="element clickable method public method_getChartNames" data-toggle="collapse" data-target=".method_getChartNames .collapse">
<h2>Return an array of the names of charts on this worksheet</h2>
<pre>getChartNames() : string[]</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response">
<code>string[]</code>The names of charts</div>
</div></div>
</div>
<a id="method_getCodeName"></a><div class="element clickable method public method_getCodeName" data-toggle="collapse" data-target=".method_getCodeName .collapse">
<h2>Return the code name of the sheet</h2>
<pre>getCodeName() : null | string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response">
<code>null</code><code>string</code>
</div>
</div></div>
</div>
<a id="method_getColumnDimension"></a><div class="element clickable method public method_getColumnDimension" data-toggle="collapse" data-target=".method_getColumnDimension .collapse">
<h2>Get column dimension at a specific column</h2>
<pre>getColumnDimension(string $pColumn, $create) : <a href="../classes/PHPExcel_Worksheet_ColumnDimension.html">\PHPExcel_Worksheet_ColumnDimension</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pColumn</h4>
<code>string</code><p>String index of the column</p></div>
<div class="subelement argument"><h4>$create</h4></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet_ColumnDimension.html">\PHPExcel_Worksheet_ColumnDimension</a></code></div>
</div></div>
</div>
<a id="method_getColumnDimensionByColumn"></a><div class="element clickable method public method_getColumnDimensionByColumn" data-toggle="collapse" data-target=".method_getColumnDimensionByColumn .collapse">
<h2>Get column dimension at a specific column by using numeric cell coordinates</h2>
<pre>getColumnDimensionByColumn(string $pColumn) : <a href="../classes/PHPExcel_Worksheet_ColumnDimension.html">\PHPExcel_Worksheet_ColumnDimension</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pColumn</h4>
<code>string</code><p>Numeric column coordinate of the cell</p></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet_ColumnDimension.html">\PHPExcel_Worksheet_ColumnDimension</a></code></div>
</div></div>
</div>
<a id="method_getColumnDimensions"></a><div class="element clickable method public method_getColumnDimensions" data-toggle="collapse" data-target=".method_getColumnDimensions .collapse">
<h2>Get collection of column dimensions</h2>
<pre>getColumnDimensions() : <a href="PHPExcel.Worksheet.ColumnDimension.html#%5CPHPExcel_Worksheet_ColumnDimension">\PHPExcel_Worksheet_ColumnDimension[]</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="PHPExcel.Worksheet.ColumnDimension.html#%5CPHPExcel_Worksheet_ColumnDimension">\PHPExcel_Worksheet_ColumnDimension[]</a></code></div>
</div></div>
</div>
<a id="method_getComment"></a><div class="element clickable method public method_getComment" data-toggle="collapse" data-target=".method_getComment .collapse">
<h2>Get comment for cell</h2>
<pre>getComment(string $pCellCoordinate) : <a href="../classes/PHPExcel_Comment.html">\PHPExcel_Comment</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCellCoordinate</h4>
<code>string</code><p>Cell coordinate to get comment for</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Comment.html">\PHPExcel_Comment</a></code></div>
</div></div>
</div>
<a id="method_getCommentByColumnAndRow"></a><div class="element clickable method public method_getCommentByColumnAndRow" data-toggle="collapse" data-target=".method_getCommentByColumnAndRow .collapse">
<h2>Get comment for cell by using numeric cell coordinates</h2>
<pre>getCommentByColumnAndRow(int $pColumn, int $pRow) : <a href="../classes/PHPExcel_Comment.html">\PHPExcel_Comment</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pColumn</h4>
<code>int</code><p>Numeric column coordinate of the cell</p></div>
<div class="subelement argument">
<h4>$pRow</h4>
<code>int</code><p>Numeric row coordinate of the cell</p></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Comment.html">\PHPExcel_Comment</a></code></div>
</div></div>
</div>
<a id="method_getComments"></a><div class="element clickable method public method_getComments" data-toggle="collapse" data-target=".method_getComments .collapse">
<h2>Get comments</h2>
<pre>getComments() : <a href="PHPExcel.Comment.html#%5CPHPExcel_Comment">\PHPExcel_Comment[]</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="PHPExcel.Comment.html#%5CPHPExcel_Comment">\PHPExcel_Comment[]</a></code></div>
</div></div>
</div>
<a id="method_getConditionalStyles"></a><div class="element clickable method public method_getConditionalStyles" data-toggle="collapse" data-target=".method_getConditionalStyles .collapse">
<h2>Get conditional styles for a cell</h2>
<pre>getConditionalStyles(string $pCoordinate) : <a href="PHPExcel.Style.Conditional.html#%5CPHPExcel_Style_Conditional">\PHPExcel_Style_Conditional[]</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCoordinate</h4>
<code>string</code>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="PHPExcel.Style.Conditional.html#%5CPHPExcel_Style_Conditional">\PHPExcel_Style_Conditional[]</a></code></div>
</div></div>
</div>
<a id="method_getConditionalStylesCollection"></a><div class="element clickable method public method_getConditionalStylesCollection" data-toggle="collapse" data-target=".method_getConditionalStylesCollection .collapse">
<h2>Get collection of conditional styles</h2>
<pre>getConditionalStylesCollection() : array</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code>array</code></div>
</div></div>
</div>
<a id="method_getDataValidation"></a><div class="element clickable method public method_getDataValidation" data-toggle="collapse" data-target=".method_getDataValidation .collapse">
<h2>Get data validation</h2>
<pre>getDataValidation(string $pCellCoordinate) </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCellCoordinate</h4>
<code>string</code><p>Cell coordinate to get data validation for</p></div>
</div></div>
</div>
<a id="method_getDataValidationCollection"></a><div class="element clickable method public method_getDataValidationCollection" data-toggle="collapse" data-target=".method_getDataValidationCollection .collapse">
<h2>Get collection of data validations</h2>
<pre>getDataValidationCollection() : <a href="PHPExcel.Cell.DataValidation.html#%5CPHPExcel_Cell_DataValidation">\PHPExcel_Cell_DataValidation[]</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="PHPExcel.Cell.DataValidation.html#%5CPHPExcel_Cell_DataValidation">\PHPExcel_Cell_DataValidation[]</a></code></div>
</div></div>
</div>
<a id="method_getDefaultColumnDimension"></a><div class="element clickable method public method_getDefaultColumnDimension" data-toggle="collapse" data-target=".method_getDefaultColumnDimension .collapse">
<h2>Get default column dimension</h2>
<pre>getDefaultColumnDimension() : <a href="../classes/PHPExcel_Worksheet_ColumnDimension.html">\PHPExcel_Worksheet_ColumnDimension</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet_ColumnDimension.html">\PHPExcel_Worksheet_ColumnDimension</a></code></div>
</div></div>
</div>
<a id="method_getDefaultRowDimension"></a><div class="element clickable method public method_getDefaultRowDimension" data-toggle="collapse" data-target=".method_getDefaultRowDimension .collapse">
<h2>Get default row dimension</h2>
<pre>getDefaultRowDimension() : <a href="../classes/PHPExcel_Worksheet_RowDimension.html">\PHPExcel_Worksheet_RowDimension</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet_RowDimension.html">\PHPExcel_Worksheet_RowDimension</a></code></div>
</div></div>
</div>
<a id="method_getDefaultStyle"></a><div class="element clickable method public method_getDefaultStyle" data-toggle="collapse" data-target=".method_getDefaultStyle .collapse">
<h2>Get default style of workbook.</h2>
<pre>getDefaultStyle() : <a href="../classes/PHPExcel_Style.html">\PHPExcel_Style</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<table class="table table-bordered"><tr>
<th>deprecated</th>
<td></td>
</tr></table>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Style.html">\PHPExcel_Style</a></code></div>
</div></div>
</div>
<a id="method_getDrawingCollection"></a><div class="element clickable method public method_getDrawingCollection" data-toggle="collapse" data-target=".method_getDrawingCollection .collapse">
<h2>Get collection of drawings</h2>
<pre>getDrawingCollection() : <a href="PHPExcel.Worksheet.BaseDrawing.html#%5CPHPExcel_Worksheet_BaseDrawing">\PHPExcel_Worksheet_BaseDrawing[]</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="PHPExcel.Worksheet.BaseDrawing.html#%5CPHPExcel_Worksheet_BaseDrawing">\PHPExcel_Worksheet_BaseDrawing[]</a></code></div>
</div></div>
</div>
<a id="method_getFreezePane"></a><div class="element clickable method public method_getFreezePane" data-toggle="collapse" data-target=".method_getFreezePane .collapse">
<h2>Get Freeze Pane</h2>
<pre>getFreezePane() : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code>string</code></div>
</div></div>
</div>
<a id="method_getHashCode"></a><div class="element clickable method public method_getHashCode" data-toggle="collapse" data-target=".method_getHashCode .collapse">
<h2>Get hash code</h2>
<pre>getHashCode() : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response">
<code>string</code>Hash code</div>
</div></div>
</div>
<a id="method_getHeaderFooter"></a><div class="element clickable method public method_getHeaderFooter" data-toggle="collapse" data-target=".method_getHeaderFooter .collapse">
<h2>Get page header/footer</h2>
<pre>getHeaderFooter() : <a href="../classes/PHPExcel_Worksheet_HeaderFooter.html">\PHPExcel_Worksheet_HeaderFooter</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet_HeaderFooter.html">\PHPExcel_Worksheet_HeaderFooter</a></code></div>
</div></div>
</div>
<a id="method_getHighestColumn"></a><div class="element clickable method public method_getHighestColumn" data-toggle="collapse" data-target=".method_getHighestColumn .collapse">
<h2>Get highest worksheet column</h2>
<pre>getHighestColumn(string $row) : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$row</h4>
<code>string</code><p>Return the data highest column for the specified row,
                                    or the highest column of any row if no row number is passed</p></div>
<h3>Returns</h3>
<div class="subelement response">
<code>string</code>Highest column name</div>
</div></div>
</div>
<a id="method_getHighestDataColumn"></a><div class="element clickable method public method_getHighestDataColumn" data-toggle="collapse" data-target=".method_getHighestDataColumn .collapse">
<h2>Get highest worksheet column that contains data</h2>
<pre>getHighestDataColumn(string $row) : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$row</h4>
<code>string</code><p>Return the highest data column for the specified row,
                                    or the highest data column of any row if no row number is passed</p></div>
<h3>Returns</h3>
<div class="subelement response">
<code>string</code>Highest column name that contains data</div>
</div></div>
</div>
<a id="method_getHighestDataRow"></a><div class="element clickable method public method_getHighestDataRow" data-toggle="collapse" data-target=".method_getHighestDataRow .collapse">
<h2>Get highest worksheet row that contains data</h2>
<pre>getHighestDataRow(string $column) : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$column</h4>
<code>string</code><p>Return the highest data row for the specified column,
                                    or the highest data row of any column if no column letter is passed</p></div>
<h3>Returns</h3>
<div class="subelement response">
<code>string</code>Highest row number that contains data</div>
</div></div>
</div>
<a id="method_getHighestRow"></a><div class="element clickable method public method_getHighestRow" data-toggle="collapse" data-target=".method_getHighestRow .collapse">
<h2>Get highest worksheet row</h2>
<pre>getHighestRow(string $column) : int</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$column</h4>
<code>string</code><p>Return the highest data row for the specified column,
                                    or the highest row of any column if no column letter is passed</p></div>
<h3>Returns</h3>
<div class="subelement response">
<code>int</code>Highest row number</div>
</div></div>
</div>
<a id="method_getHighestRowAndColumn"></a><div class="element clickable method public method_getHighestRowAndColumn" data-toggle="collapse" data-target=".method_getHighestRowAndColumn .collapse">
<h2>Get highest worksheet column and highest row that have cell records</h2>
<pre>getHighestRowAndColumn() : array</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response">
<code>array</code>Highest column name and highest row number</div>
</div></div>
</div>
<a id="method_getHyperlink"></a><div class="element clickable method public method_getHyperlink" data-toggle="collapse" data-target=".method_getHyperlink .collapse">
<h2>Get hyperlink</h2>
<pre>getHyperlink(string $pCellCoordinate) </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCellCoordinate</h4>
<code>string</code><p>Cell coordinate to get hyperlink for</p></div>
</div></div>
</div>
<a id="method_getHyperlinkCollection"></a><div class="element clickable method public method_getHyperlinkCollection" data-toggle="collapse" data-target=".method_getHyperlinkCollection .collapse">
<h2>Get collection of hyperlinks</h2>
<pre>getHyperlinkCollection() : <a href="PHPExcel.Cell.Hyperlink.html#%5CPHPExcel_Cell_Hyperlink">\PHPExcel_Cell_Hyperlink[]</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="PHPExcel.Cell.Hyperlink.html#%5CPHPExcel_Cell_Hyperlink">\PHPExcel_Cell_Hyperlink[]</a></code></div>
</div></div>
</div>
<a id="method_getInvalidCharacters"></a><div class="element clickable method public method_getInvalidCharacters" data-toggle="collapse" data-target=".method_getInvalidCharacters .collapse">
<h2>Get array of invalid characters for sheet title</h2>
<pre>getInvalidCharacters() : array</pre>
<div class="labels"><span class="label">Static</span></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code>array</code></div>
</div></div>
</div>
<a id="method_getMergeCells"></a><div class="element clickable method public method_getMergeCells" data-toggle="collapse" data-target=".method_getMergeCells .collapse">
<h2>Get merge cells array.</h2>
<pre>getMergeCells() : array[]</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code>array[]</code></div>
</div></div>
</div>
<a id="method_getPageMargins"></a><div class="element clickable method public method_getPageMargins" data-toggle="collapse" data-target=".method_getPageMargins .collapse">
<h2>Get page margins</h2>
<pre>getPageMargins() : <a href="../classes/PHPExcel_Worksheet_PageMargins.html">\PHPExcel_Worksheet_PageMargins</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet_PageMargins.html">\PHPExcel_Worksheet_PageMargins</a></code></div>
</div></div>
</div>
<a id="method_getPageSetup"></a><div class="element clickable method public method_getPageSetup" data-toggle="collapse" data-target=".method_getPageSetup .collapse">
<h2>Get page setup</h2>
<pre>getPageSetup() : <a href="../classes/PHPExcel_Worksheet_PageSetup.html">\PHPExcel_Worksheet_PageSetup</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet_PageSetup.html">\PHPExcel_Worksheet_PageSetup</a></code></div>
</div></div>
</div>
<a id="method_getParent"></a><div class="element clickable method public method_getParent" data-toggle="collapse" data-target=".method_getParent .collapse">
<h2>Get parent</h2>
<pre>getParent() : <a href="../classes/PHPExcel.html">\PHPExcel</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel.html">\PHPExcel</a></code></div>
</div></div>
</div>
<a id="method_getPrintGridlines"></a><div class="element clickable method public method_getPrintGridlines" data-toggle="collapse" data-target=".method_getPrintGridlines .collapse">
<h2>Print gridlines?</h2>
<pre>getPrintGridlines() : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code>boolean</code></div>
</div></div>
</div>
<a id="method_getProtectedCells"></a><div class="element clickable method public method_getProtectedCells" data-toggle="collapse" data-target=".method_getProtectedCells .collapse">
<h2>Get protected cells</h2>
<pre>getProtectedCells() : array[]</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code>array[]</code></div>
</div></div>
</div>
<a id="method_getProtection"></a><div class="element clickable method public method_getProtection" data-toggle="collapse" data-target=".method_getProtection .collapse">
<h2>Get Protection</h2>
<pre>getProtection() : <a href="../classes/PHPExcel_Worksheet_Protection.html">\PHPExcel_Worksheet_Protection</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet_Protection.html">\PHPExcel_Worksheet_Protection</a></code></div>
</div></div>
</div>
<a id="method_getRightToLeft"></a><div class="element clickable method public method_getRightToLeft" data-toggle="collapse" data-target=".method_getRightToLeft .collapse">
<h2>Get right-to-left</h2>
<pre>getRightToLeft() : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code>boolean</code></div>
</div></div>
</div>
<a id="method_getRowDimension"></a><div class="element clickable method public method_getRowDimension" data-toggle="collapse" data-target=".method_getRowDimension .collapse">
<h2>Get row dimension at a specific row</h2>
<pre>getRowDimension(int $pRow, $create) : <a href="../classes/PHPExcel_Worksheet_RowDimension.html">\PHPExcel_Worksheet_RowDimension</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pRow</h4>
<code>int</code><p>Numeric index of the row</p></div>
<div class="subelement argument"><h4>$create</h4></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet_RowDimension.html">\PHPExcel_Worksheet_RowDimension</a></code></div>
</div></div>
</div>
<a id="method_getRowDimensions"></a><div class="element clickable method public method_getRowDimensions" data-toggle="collapse" data-target=".method_getRowDimensions .collapse">
<h2>Get collection of row dimensions</h2>
<pre>getRowDimensions() : <a href="PHPExcel.Worksheet.RowDimension.html#%5CPHPExcel_Worksheet_RowDimension">\PHPExcel_Worksheet_RowDimension[]</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="PHPExcel.Worksheet.RowDimension.html#%5CPHPExcel_Worksheet_RowDimension">\PHPExcel_Worksheet_RowDimension[]</a></code></div>
</div></div>
</div>
<a id="method_getRowIterator"></a><div class="element clickable method public method_getRowIterator" data-toggle="collapse" data-target=".method_getRowIterator .collapse">
<h2>Get row iterator</h2>
<pre>getRowIterator(integer $startRow) : <a href="../classes/PHPExcel_Worksheet_RowIterator.html">\PHPExcel_Worksheet_RowIterator</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$startRow</h4>
<code>integer</code><p>The row number at which to start iterating</p></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet_RowIterator.html">\PHPExcel_Worksheet_RowIterator</a></code></div>
</div></div>
</div>
<a id="method_getSelectedCell"></a><div class="element clickable method public method_getSelectedCell" data-toggle="collapse" data-target=".method_getSelectedCell .collapse">
<h2>Get selected cell</h2>
<pre>getSelectedCell() : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<table class="table table-bordered"><tr>
<th>deprecated</th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code>string</code></div>
</div></div>
</div>
<a id="method_getSelectedCells"></a><div class="element clickable method public method_getSelectedCells" data-toggle="collapse" data-target=".method_getSelectedCells .collapse">
<h2>Get selected cells</h2>
<pre>getSelectedCells() : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code>string</code></div>
</div></div>
</div>
<a id="method_getSheetState"></a><div class="element clickable method public method_getSheetState" data-toggle="collapse" data-target=".method_getSheetState .collapse">
<h2>Get sheet state</h2>
<pre>getSheetState() : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response">
<code>string</code>Sheet state (visible, hidden, veryHidden)</div>
</div></div>
</div>
<a id="method_getSheetView"></a><div class="element clickable method public method_getSheetView" data-toggle="collapse" data-target=".method_getSheetView .collapse">
<h2>Get sheet view</h2>
<pre>getSheetView() : <a href="../classes/PHPExcel_Worksheet_SheetView.html">\PHPExcel_Worksheet_SheetView</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet_SheetView.html">\PHPExcel_Worksheet_SheetView</a></code></div>
</div></div>
</div>
<a id="method_getShowGridlines"></a><div class="element clickable method public method_getShowGridlines" data-toggle="collapse" data-target=".method_getShowGridlines .collapse">
<h2>Show gridlines?</h2>
<pre>getShowGridlines() : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code>boolean</code></div>
</div></div>
</div>
<a id="method_getShowRowColHeaders"></a><div class="element clickable method public method_getShowRowColHeaders" data-toggle="collapse" data-target=".method_getShowRowColHeaders .collapse">
<h2>Show row and column headers?</h2>
<pre>getShowRowColHeaders() : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code>boolean</code></div>
</div></div>
</div>
<a id="method_getShowSummaryBelow"></a><div class="element clickable method public method_getShowSummaryBelow" data-toggle="collapse" data-target=".method_getShowSummaryBelow .collapse">
<h2>Show summary below? (Row/Column outlining)</h2>
<pre>getShowSummaryBelow() : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code>boolean</code></div>
</div></div>
</div>
<a id="method_getShowSummaryRight"></a><div class="element clickable method public method_getShowSummaryRight" data-toggle="collapse" data-target=".method_getShowSummaryRight .collapse">
<h2>Show summary right? (Row/Column outlining)</h2>
<pre>getShowSummaryRight() : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code>boolean</code></div>
</div></div>
</div>
<a id="method_getStyle"></a><div class="element clickable method public method_getStyle" data-toggle="collapse" data-target=".method_getStyle .collapse">
<h2>Get style for cell</h2>
<pre>getStyle(string $pCellCoordinate) : <a href="../classes/PHPExcel_Style.html">\PHPExcel_Style</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCellCoordinate</h4>
<code>string</code><p>Cell coordinate to get style for</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Style.html">\PHPExcel_Style</a></code></div>
</div></div>
</div>
<a id="method_getStyleByColumnAndRow"></a><div class="element clickable method public method_getStyleByColumnAndRow" data-toggle="collapse" data-target=".method_getStyleByColumnAndRow .collapse">
<h2>Get style for cell by using numeric cell coordinates</h2>
<pre>getStyleByColumnAndRow(int $pColumn, int $pRow) : <a href="../classes/PHPExcel_Style.html">\PHPExcel_Style</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pColumn</h4>
<code>int</code><p>Numeric column coordinate of the cell</p></div>
<div class="subelement argument">
<h4>$pRow</h4>
<code>int</code><p>Numeric row coordinate of the cell</p></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Style.html">\PHPExcel_Style</a></code></div>
</div></div>
</div>
<a id="method_getStyles"></a><div class="element clickable method public method_getStyles" data-toggle="collapse" data-target=".method_getStyles .collapse">
<h2>Get styles</h2>
<pre>getStyles() : <a href="PHPExcel.Style.html#%5CPHPExcel_Style">\PHPExcel_Style[]</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="PHPExcel.Style.html#%5CPHPExcel_Style">\PHPExcel_Style[]</a></code></div>
</div></div>
</div>
<a id="method_getTabColor"></a><div class="element clickable method public method_getTabColor" data-toggle="collapse" data-target=".method_getTabColor .collapse">
<h2>Get tab color</h2>
<pre>getTabColor() : <a href="../classes/PHPExcel_Style_Color.html">\PHPExcel_Style_Color</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Style_Color.html">\PHPExcel_Style_Color</a></code></div>
</div></div>
</div>
<a id="method_getTitle"></a><div class="element clickable method public method_getTitle" data-toggle="collapse" data-target=".method_getTitle .collapse">
<h2>Get title</h2>
<pre>getTitle() : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code>string</code></div>
</div></div>
</div>
<a id="method_hasCodeName"></a><div class="element clickable method public method_hasCodeName" data-toggle="collapse" data-target=".method_hasCodeName .collapse">
<h2>Sheet has a code name ?</h2>
<pre>hasCodeName() : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code>boolean</code></div>
</div></div>
</div>
<a id="method_hyperlinkExists"></a><div class="element clickable method public method_hyperlinkExists" data-toggle="collapse" data-target=".method_hyperlinkExists .collapse">
<h2>Hyperlink at a specific coordinate exists?</h2>
<pre>hyperlinkExists(string $pCoordinate) : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCoordinate</h4>
<code>string</code>
</div>
<h3>Returns</h3>
<div class="subelement response"><code>boolean</code></div>
</div></div>
</div>
<a id="method_insertNewColumnBefore"></a><div class="element clickable method public method_insertNewColumnBefore" data-toggle="collapse" data-target=".method_insertNewColumnBefore .collapse">
<h2>Insert a new column, updating all possible related data</h2>
<pre>insertNewColumnBefore(int $pBefore, int $pNumCols) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pBefore</h4>
<code>int</code><p>Insert before this one</p></div>
<div class="subelement argument">
<h4>$pNumCols</h4>
<code>int</code><p>Number of columns to insert</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_insertNewColumnBeforeByIndex"></a><div class="element clickable method public method_insertNewColumnBeforeByIndex" data-toggle="collapse" data-target=".method_insertNewColumnBeforeByIndex .collapse">
<h2>Insert a new column, updating all possible related data</h2>
<pre>insertNewColumnBeforeByIndex(int $pBefore, int $pNumCols) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pBefore</h4>
<code>int</code><p>Insert before this one (numeric column coordinate of the cell)</p>
</div>
<div class="subelement argument">
<h4>$pNumCols</h4>
<code>int</code><p>Number of columns to insert</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_insertNewRowBefore"></a><div class="element clickable method public method_insertNewRowBefore" data-toggle="collapse" data-target=".method_insertNewRowBefore .collapse">
<h2>Insert a new row, updating all possible related data</h2>
<pre>insertNewRowBefore(int $pBefore, int $pNumRows) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pBefore</h4>
<code>int</code><p>Insert before this one</p></div>
<div class="subelement argument">
<h4>$pNumRows</h4>
<code>int</code><p>Number of rows to insert</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_isTabColorSet"></a><div class="element clickable method public method_isTabColorSet" data-toggle="collapse" data-target=".method_isTabColorSet .collapse">
<h2>Tab color set?</h2>
<pre>isTabColorSet() : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code>boolean</code></div>
</div></div>
</div>
<a id="method_mergeCells"></a><div class="element clickable method public method_mergeCells" data-toggle="collapse" data-target=".method_mergeCells .collapse">
<h2>Set merge on a cell range</h2>
<pre>mergeCells(string $pRange) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pRange</h4>
<code>string</code><p>Cell range (e.g. A1:E1)</p>
</div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_mergeCellsByColumnAndRow"></a><div class="element clickable method public method_mergeCellsByColumnAndRow" data-toggle="collapse" data-target=".method_mergeCellsByColumnAndRow .collapse">
<h2>Set merge on a cell range by using numeric cell coordinates</h2>
<pre>mergeCellsByColumnAndRow(int $pColumn1, int $pRow1, int $pColumn2, int $pRow2) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pColumn1</h4>
<code>int</code><p>Numeric column coordinate of the first cell</p></div>
<div class="subelement argument">
<h4>$pRow1</h4>
<code>int</code><p>Numeric row coordinate of the first cell</p></div>
<div class="subelement argument">
<h4>$pColumn2</h4>
<code>int</code><p>Numeric column coordinate of the last cell</p></div>
<div class="subelement argument">
<h4>$pRow2</h4>
<code>int</code><p>Numeric row coordinate of the last cell</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_namedRangeToArray"></a><div class="element clickable method public method_namedRangeToArray" data-toggle="collapse" data-target=".method_namedRangeToArray .collapse">
<h2>Create array from a range of cells</h2>
<pre>namedRangeToArray(string $pNamedRange, mixed $nullValue, boolean $calculateFormulas, boolean $formatData, boolean $returnCellRef) : array</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pNamedRange</h4>
<code>string</code><p>Name of the Named Range</p></div>
<div class="subelement argument">
<h4>$nullValue</h4>
<code>mixed</code><p>Value returned in the array entry if a cell doesn't exist</p>
</div>
<div class="subelement argument">
<h4>$calculateFormulas</h4>
<code>boolean</code><p>Should formulas be calculated?</p>
</div>
<div class="subelement argument">
<h4>$formatData</h4>
<code>boolean</code><p>Should formatting be applied to cell values?</p>
</div>
<div class="subelement argument">
<h4>$returnCellRef</h4>
<code>boolean</code><p>False - Return a simple array of rows and columns indexed by number counting from zero
                               True - Return rows and columns indexed by their actual row and column IDs</p>
</div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code>array</code></div>
</div></div>
</div>
<a id="method_protectCells"></a><div class="element clickable method public method_protectCells" data-toggle="collapse" data-target=".method_protectCells .collapse">
<h2>Set protection on a cell range</h2>
<pre>protectCells(string $pRange, string $pPassword, boolean $pAlreadyHashed) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pRange</h4>
<code>string</code><p>Cell (e.g. A1) or cell range (e.g. A1:E1)</p>
</div>
<div class="subelement argument">
<h4>$pPassword</h4>
<code>string</code><p>Password to unlock the protection</p></div>
<div class="subelement argument">
<h4>$pAlreadyHashed</h4>
<code>boolean</code><p>If the password has already been hashed, set this to true</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_protectCellsByColumnAndRow"></a><div class="element clickable method public method_protectCellsByColumnAndRow" data-toggle="collapse" data-target=".method_protectCellsByColumnAndRow .collapse">
<h2>Set protection on a cell range by using numeric cell coordinates</h2>
<pre>protectCellsByColumnAndRow(int $pColumn1, int $pRow1, int $pColumn2, int $pRow2, string $pPassword, boolean $pAlreadyHashed) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pColumn1</h4>
<code>int</code><p>Numeric column coordinate of the first cell</p></div>
<div class="subelement argument">
<h4>$pRow1</h4>
<code>int</code><p>Numeric row coordinate of the first cell</p></div>
<div class="subelement argument">
<h4>$pColumn2</h4>
<code>int</code><p>Numeric column coordinate of the last cell</p></div>
<div class="subelement argument">
<h4>$pRow2</h4>
<code>int</code><p>Numeric row coordinate of the last cell</p></div>
<div class="subelement argument">
<h4>$pPassword</h4>
<code>string</code><p>Password to unlock the protection</p></div>
<div class="subelement argument">
<h4>$pAlreadyHashed</h4>
<code>boolean</code><p>If the password has already been hashed, set this to true</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_rangeToArray"></a><div class="element clickable method public method_rangeToArray" data-toggle="collapse" data-target=".method_rangeToArray .collapse">
<h2>Create array from a range of cells</h2>
<pre>rangeToArray(string $pRange, mixed $nullValue, boolean $calculateFormulas, boolean $formatData, boolean $returnCellRef) : array</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pRange</h4>
<code>string</code><p>Range of cells (i.e. "A1:B10"), or just one cell (i.e. "A1")</p>
</div>
<div class="subelement argument">
<h4>$nullValue</h4>
<code>mixed</code><p>Value returned in the array entry if a cell doesn't exist</p>
</div>
<div class="subelement argument">
<h4>$calculateFormulas</h4>
<code>boolean</code><p>Should formulas be calculated?</p>
</div>
<div class="subelement argument">
<h4>$formatData</h4>
<code>boolean</code><p>Should formatting be applied to cell values?</p>
</div>
<div class="subelement argument">
<h4>$returnCellRef</h4>
<code>boolean</code><p>False - Return a simple array of rows and columns indexed by number counting from zero
                              True - Return rows and columns indexed by their actual row and column IDs</p>
</div>
<h3>Returns</h3>
<div class="subelement response"><code>array</code></div>
</div></div>
</div>
<a id="method_rebindParent"></a><div class="element clickable method public method_rebindParent" data-toggle="collapse" data-target=".method_rebindParent .collapse">
<h2>Re-bind parent</h2>
<pre>rebindParent(\PHPExcel $parent) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$parent</h4>
<code><a href="../classes/PHPExcel.html">\PHPExcel</a></code>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_refreshColumnDimensions"></a><div class="element clickable method public method_refreshColumnDimensions" data-toggle="collapse" data-target=".method_refreshColumnDimensions .collapse">
<h2>Refresh column dimensions</h2>
<pre>refreshColumnDimensions() : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_refreshRowDimensions"></a><div class="element clickable method public method_refreshRowDimensions" data-toggle="collapse" data-target=".method_refreshRowDimensions .collapse">
<h2>Refresh row dimensions</h2>
<pre>refreshRowDimensions() : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_removeAutoFilter"></a><div class="element clickable method public method_removeAutoFilter" data-toggle="collapse" data-target=".method_removeAutoFilter .collapse">
<h2>Remove autofilter</h2>
<pre>removeAutoFilter() : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_removeColumn"></a><div class="element clickable method public method_removeColumn" data-toggle="collapse" data-target=".method_removeColumn .collapse">
<h2>Remove a column, updating all possible related data</h2>
<pre>removeColumn(int $pColumn, int $pNumCols) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pColumn</h4>
<code>int</code><p>Remove starting with this one</p></div>
<div class="subelement argument">
<h4>$pNumCols</h4>
<code>int</code><p>Number of columns to remove</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_removeColumnByIndex"></a><div class="element clickable method public method_removeColumnByIndex" data-toggle="collapse" data-target=".method_removeColumnByIndex .collapse">
<h2>Remove a column, updating all possible related data</h2>
<pre>removeColumnByIndex(int $pColumn, int $pNumCols) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pColumn</h4>
<code>int</code><p>Remove starting with this one (numeric column coordinate of the cell)</p>
</div>
<div class="subelement argument">
<h4>$pNumCols</h4>
<code>int</code><p>Number of columns to remove</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_removeConditionalStyles"></a><div class="element clickable method public method_removeConditionalStyles" data-toggle="collapse" data-target=".method_removeConditionalStyles .collapse">
<h2>Removes conditional styles for a cell</h2>
<pre>removeConditionalStyles(string $pCoordinate) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCoordinate</h4>
<code>string</code>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_removeRow"></a><div class="element clickable method public method_removeRow" data-toggle="collapse" data-target=".method_removeRow .collapse">
<h2>Delete a row, updating all possible related data</h2>
<pre>removeRow(int $pRow, int $pNumRows) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pRow</h4>
<code>int</code><p>Remove starting with this one</p></div>
<div class="subelement argument">
<h4>$pNumRows</h4>
<code>int</code><p>Number of rows to remove</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_resetTabColor"></a><div class="element clickable method public method_resetTabColor" data-toggle="collapse" data-target=".method_resetTabColor .collapse">
<h2>Reset tab color</h2>
<pre>resetTabColor() : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setAutoFilter"></a><div class="element clickable method public method_setAutoFilter" data-toggle="collapse" data-target=".method_setAutoFilter .collapse">
<h2>Set AutoFilter</h2>
<pre>setAutoFilter($pValue) </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"><p>@param    PHPExcel_Worksheet_AutoFilter|string   $pValue
           A simple string containing a Cell range like 'A1:E10' is permitted for backward compatibility</p></div>
<h3>Parameters</h3>
<div class="subelement argument"><h4>$pValue</h4></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td>@return PHPExcel_Worksheet</td>
</tr></table>
</div></div>
</div>
<a id="method_setAutoFilterByColumnAndRow"></a><div class="element clickable method public method_setAutoFilterByColumnAndRow" data-toggle="collapse" data-target=".method_setAutoFilterByColumnAndRow .collapse">
<h2>Set Autofilter Range by using numeric cell coordinates</h2>
<pre>setAutoFilterByColumnAndRow($pColumn1, integer $pRow1, $pColumn2, $pRow2) </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"><p>@param  integer  $pColumn1    Numeric column coordinate of the first cell</p></div>
<h3>Parameters</h3>
<div class="subelement argument"><h4>$pColumn1</h4></div>
<div class="subelement argument">
<h4>$pRow1</h4>
<code>integer</code><p>Numeric row coordinate of the first cell
   @param  integer  $pColumn2    Numeric column coordinate of the second cell
   @param  integer  $pRow2       Numeric row coordinate of the second cell
   @throws    PHPExcel_Exception
   @return PHPExcel_Worksheet</p>
</div>
<div class="subelement argument"><h4>$pColumn2</h4></div>
<div class="subelement argument"><h4>$pRow2</h4></div>
</div></div>
</div>
<a id="method_setBreak"></a><div class="element clickable method public method_setBreak" data-toggle="collapse" data-target=".method_setBreak .collapse">
<h2>Set break on a cell</h2>
<pre>setBreak(string $pCell, int $pBreak) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCell</h4>
<code>string</code><p>Cell coordinate (e.g. A1)</p>
</div>
<div class="subelement argument">
<h4>$pBreak</h4>
<code>int</code><p>Break type (type of PHPExcel_Worksheet::BREAK_*)</p>
</div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setBreakByColumnAndRow"></a><div class="element clickable method public method_setBreakByColumnAndRow" data-toggle="collapse" data-target=".method_setBreakByColumnAndRow .collapse">
<h2>Set break on a cell by using numeric cell coordinates</h2>
<pre>setBreakByColumnAndRow(integer $pColumn, integer $pRow, integer $pBreak) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pColumn</h4>
<code>integer</code><p>Numeric column coordinate of the cell</p></div>
<div class="subelement argument">
<h4>$pRow</h4>
<code>integer</code><p>Numeric row coordinate of the cell</p></div>
<div class="subelement argument">
<h4>$pBreak</h4>
<code>integer</code><p>Break type (type of PHPExcel_Worksheet::BREAK_*)</p>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setCellValue"></a><div class="element clickable method public method_setCellValue" data-toggle="collapse" data-target=".method_setCellValue .collapse">
<h2>Set a cell value</h2>
<pre>setCellValue(string $pCoordinate, mixed $pValue, bool $returnCell) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a> | <a href="../classes/PHPExcel_Cell.html">\PHPExcel_Cell</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCoordinate</h4>
<code>string</code><p>Coordinate of the cell</p></div>
<div class="subelement argument">
<h4>$pValue</h4>
<code>mixed</code><p>Value of the cell</p></div>
<div class="subelement argument">
<h4>$returnCell</h4>
<code>bool</code><p>Return the worksheet (false, default) or the cell (true)</p>
</div>
<h3>Returns</h3>
<div class="subelement response">
<code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code><code><a href="../classes/PHPExcel_Cell.html">\PHPExcel_Cell</a></code>Depending on the last parameter being specified</div>
</div></div>
</div>
<a id="method_setCellValueByColumnAndRow"></a><div class="element clickable method public method_setCellValueByColumnAndRow" data-toggle="collapse" data-target=".method_setCellValueByColumnAndRow .collapse">
<h2>Set a cell value by using numeric cell coordinates</h2>
<pre>setCellValueByColumnAndRow(string $pColumn, string $pRow, mixed $pValue, bool $returnCell) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a> | <a href="../classes/PHPExcel_Cell.html">\PHPExcel_Cell</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pColumn</h4>
<code>string</code><p>Numeric column coordinate of the cell (A = 0)</p>
</div>
<div class="subelement argument">
<h4>$pRow</h4>
<code>string</code><p>Numeric row coordinate of the cell</p></div>
<div class="subelement argument">
<h4>$pValue</h4>
<code>mixed</code><p>Value of the cell</p></div>
<div class="subelement argument">
<h4>$returnCell</h4>
<code>bool</code><p>Return the worksheet (false, default) or the cell (true)</p>
</div>
<h3>Returns</h3>
<div class="subelement response">
<code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code><code><a href="../classes/PHPExcel_Cell.html">\PHPExcel_Cell</a></code>Depending on the last parameter being specified</div>
</div></div>
</div>
<a id="method_setCellValueExplicit"></a><div class="element clickable method public method_setCellValueExplicit" data-toggle="collapse" data-target=".method_setCellValueExplicit .collapse">
<h2>Set a cell value</h2>
<pre>setCellValueExplicit(string $pCoordinate, mixed $pValue, string $pDataType, bool $returnCell) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a> | <a href="../classes/PHPExcel_Cell.html">\PHPExcel_Cell</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCoordinate</h4>
<code>string</code><p>Coordinate of the cell</p></div>
<div class="subelement argument">
<h4>$pValue</h4>
<code>mixed</code><p>Value of the cell</p></div>
<div class="subelement argument">
<h4>$pDataType</h4>
<code>string</code><p>Explicit data type</p></div>
<div class="subelement argument">
<h4>$returnCell</h4>
<code>bool</code><p>Return the worksheet (false, default) or the cell (true)</p>
</div>
<h3>Returns</h3>
<div class="subelement response">
<code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code><code><a href="../classes/PHPExcel_Cell.html">\PHPExcel_Cell</a></code>Depending on the last parameter being specified</div>
</div></div>
</div>
<a id="method_setCellValueExplicitByColumnAndRow"></a><div class="element clickable method public method_setCellValueExplicitByColumnAndRow" data-toggle="collapse" data-target=".method_setCellValueExplicitByColumnAndRow .collapse">
<h2>Set a cell value by using numeric cell coordinates</h2>
<pre>setCellValueExplicitByColumnAndRow(string $pColumn, string $pRow, mixed $pValue, string $pDataType, bool $returnCell) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a> | <a href="../classes/PHPExcel_Cell.html">\PHPExcel_Cell</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pColumn</h4>
<code>string</code><p>Numeric column coordinate of the cell</p></div>
<div class="subelement argument">
<h4>$pRow</h4>
<code>string</code><p>Numeric row coordinate of the cell</p></div>
<div class="subelement argument">
<h4>$pValue</h4>
<code>mixed</code><p>Value of the cell</p></div>
<div class="subelement argument">
<h4>$pDataType</h4>
<code>string</code><p>Explicit data type</p></div>
<div class="subelement argument">
<h4>$returnCell</h4>
<code>bool</code><p>Return the worksheet (false, default) or the cell (true)</p>
</div>
<h3>Returns</h3>
<div class="subelement response">
<code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code><code><a href="../classes/PHPExcel_Cell.html">\PHPExcel_Cell</a></code>Depending on the last parameter being specified</div>
</div></div>
</div>
<a id="method_setCodeName"></a><div class="element clickable method public method_setCodeName" data-toggle="collapse" data-target=".method_setCodeName .collapse">
<h2>Define the code name of the sheet</h2>
<pre>setCodeName(null | string $pValue) : \objWorksheet</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pValue</h4>
<code>null</code><code>string</code><p>Same rule as Title minus space not allowed (but, like Excel, change silently space to underscore)</p>
</div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code>\objWorksheet</code></div>
</div></div>
</div>
<a id="method_setComments"></a><div class="element clickable method public method_setComments" data-toggle="collapse" data-target=".method_setComments .collapse">
<h2>Set comments array for the entire sheet.</h2>
<pre>setComments(array $pValue) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pValue</h4>
<code>array</code><p>of PHPExcel_Comment</p></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setConditionalStyles"></a><div class="element clickable method public method_setConditionalStyles" data-toggle="collapse" data-target=".method_setConditionalStyles .collapse">
<h2>Set conditional styles</h2>
<pre>setConditionalStyles($pCoordinate, $pValue) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCoordinate</h4><p>string E.g. 'A1'</p>
</div>
<div class="subelement argument">
<h4>$pValue</h4><p>PHPExcel_Style_Conditional[]</p>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setDataValidation"></a><div class="element clickable method public method_setDataValidation" data-toggle="collapse" data-target=".method_setDataValidation .collapse">
<h2>Set data validation</h2>
<pre>setDataValidation(string $pCellCoordinate, \PHPExcel_Cell_DataValidation $pDataValidation) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCellCoordinate</h4>
<code>string</code><p>Cell coordinate to insert data validation</p></div>
<div class="subelement argument">
<h4>$pDataValidation</h4>
<code><a href="../classes/PHPExcel_Cell_DataValidation.html">\PHPExcel_Cell_DataValidation</a></code>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setDefaultStyle"></a><div class="element clickable method public method_setDefaultStyle" data-toggle="collapse" data-target=".method_setDefaultStyle .collapse">
<h2>Set default style - should only be used by PHPExcel_IReader implementations!</h2>
<pre>setDefaultStyle(\PHPExcel_Style $pValue) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<table class="table table-bordered"><tr>
<th>deprecated</th>
<td></td>
</tr></table>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pValue</h4>
<code><a href="../classes/PHPExcel_Style.html">\PHPExcel_Style</a></code>
</div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setHeaderFooter"></a><div class="element clickable method public method_setHeaderFooter" data-toggle="collapse" data-target=".method_setHeaderFooter .collapse">
<h2>Set page header/footer</h2>
<pre>setHeaderFooter(\PHPExcel_Worksheet_HeaderFooter $pValue) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pValue</h4>
<code><a href="../classes/PHPExcel_Worksheet_HeaderFooter.html">\PHPExcel_Worksheet_HeaderFooter</a></code>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setHyperlink"></a><div class="element clickable method public method_setHyperlink" data-toggle="collapse" data-target=".method_setHyperlink .collapse">
<h2>Set hyperlnk</h2>
<pre>setHyperlink(string $pCellCoordinate, \PHPExcel_Cell_Hyperlink $pHyperlink) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCellCoordinate</h4>
<code>string</code><p>Cell coordinate to insert hyperlink</p></div>
<div class="subelement argument">
<h4>$pHyperlink</h4>
<code><a href="../classes/PHPExcel_Cell_Hyperlink.html">\PHPExcel_Cell_Hyperlink</a></code>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setMergeCells"></a><div class="element clickable method public method_setMergeCells" data-toggle="collapse" data-target=".method_setMergeCells .collapse">
<h2>Set merge cells array for the entire sheet.</h2>
<pre>setMergeCells(array $pValue) </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"><p>Use instead mergeCells() to merge
a single cell range.</p></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pValue</h4>
<code>array</code>
</div>
</div></div>
</div>
<a id="method_setPageMargins"></a><div class="element clickable method public method_setPageMargins" data-toggle="collapse" data-target=".method_setPageMargins .collapse">
<h2>Set page margins</h2>
<pre>setPageMargins(\PHPExcel_Worksheet_PageMargins $pValue) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pValue</h4>
<code><a href="../classes/PHPExcel_Worksheet_PageMargins.html">\PHPExcel_Worksheet_PageMargins</a></code>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setPageSetup"></a><div class="element clickable method public method_setPageSetup" data-toggle="collapse" data-target=".method_setPageSetup .collapse">
<h2>Set page setup</h2>
<pre>setPageSetup(\PHPExcel_Worksheet_PageSetup $pValue) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pValue</h4>
<code><a href="../classes/PHPExcel_Worksheet_PageSetup.html">\PHPExcel_Worksheet_PageSetup</a></code>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setPrintGridlines"></a><div class="element clickable method public method_setPrintGridlines" data-toggle="collapse" data-target=".method_setPrintGridlines .collapse">
<h2>Set print gridlines</h2>
<pre>setPrintGridlines(boolean $pValue) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pValue</h4>
<code>boolean</code><p>Print gridlines (true/false)</p>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setProtection"></a><div class="element clickable method public method_setProtection" data-toggle="collapse" data-target=".method_setProtection .collapse">
<h2>Set Protection</h2>
<pre>setProtection(\PHPExcel_Worksheet_Protection $pValue) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pValue</h4>
<code><a href="../classes/PHPExcel_Worksheet_Protection.html">\PHPExcel_Worksheet_Protection</a></code>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setRightToLeft"></a><div class="element clickable method public method_setRightToLeft" data-toggle="collapse" data-target=".method_setRightToLeft .collapse">
<h2>Set right-to-left</h2>
<pre>setRightToLeft(boolean $value) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$value</h4>
<code>boolean</code><p>Right-to-left true/false</p>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setSelectedCell"></a><div class="element clickable method public method_setSelectedCell" data-toggle="collapse" data-target=".method_setSelectedCell .collapse">
<h2>Selected cell</h2>
<pre>setSelectedCell(string $pCoordinate) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCoordinate</h4>
<code>string</code><p>Cell (i.e. A1)</p>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setSelectedCellByColumnAndRow"></a><div class="element clickable method public method_setSelectedCellByColumnAndRow" data-toggle="collapse" data-target=".method_setSelectedCellByColumnAndRow .collapse">
<h2>Selected cell by using numeric cell coordinates</h2>
<pre>setSelectedCellByColumnAndRow(int $pColumn, int $pRow) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pColumn</h4>
<code>int</code><p>Numeric column coordinate of the cell</p></div>
<div class="subelement argument">
<h4>$pRow</h4>
<code>int</code><p>Numeric row coordinate of the cell</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setSelectedCells"></a><div class="element clickable method public method_setSelectedCells" data-toggle="collapse" data-target=".method_setSelectedCells .collapse">
<h2>Select a range of cells.</h2>
<pre>setSelectedCells(string $pCoordinate) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCoordinate</h4>
<code>string</code><p>Cell range, examples: 'A1', 'B2:G5', 'A:C', '3:6'</p>
</div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setSharedStyle"></a><div class="element clickable method public method_setSharedStyle" data-toggle="collapse" data-target=".method_setSharedStyle .collapse">
<h2>Set shared cell style to a range of cells</h2>
<pre>setSharedStyle(\PHPExcel_Style $pSharedCellStyle, string $pRange) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"><p>Please note that this will overwrite existing cell styles for cells in range!</p></div>
<table class="table table-bordered"><tr>
<th>deprecated</th>
<td></td>
</tr></table>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pSharedCellStyle</h4>
<code><a href="../classes/PHPExcel_Style.html">\PHPExcel_Style</a></code><p>Cell style to share</p></div>
<div class="subelement argument">
<h4>$pRange</h4>
<code>string</code><p>Range of cells (i.e. "A1:B10"), or just one cell (i.e. "A1")</p>
</div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setSheetState"></a><div class="element clickable method public method_setSheetState" data-toggle="collapse" data-target=".method_setSheetState .collapse">
<h2>Set sheet state</h2>
<pre>setSheetState(string $value) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$value</h4>
<code>string</code><p>Sheet state (visible, hidden, veryHidden)</p>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setSheetView"></a><div class="element clickable method public method_setSheetView" data-toggle="collapse" data-target=".method_setSheetView .collapse">
<h2>Set sheet view</h2>
<pre>setSheetView(\PHPExcel_Worksheet_SheetView $pValue) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pValue</h4>
<code><a href="../classes/PHPExcel_Worksheet_SheetView.html">\PHPExcel_Worksheet_SheetView</a></code>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setShowGridlines"></a><div class="element clickable method public method_setShowGridlines" data-toggle="collapse" data-target=".method_setShowGridlines .collapse">
<h2>Set show gridlines</h2>
<pre>setShowGridlines(boolean $pValue) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pValue</h4>
<code>boolean</code><p>Show gridlines (true/false)</p>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setShowRowColHeaders"></a><div class="element clickable method public method_setShowRowColHeaders" data-toggle="collapse" data-target=".method_setShowRowColHeaders .collapse">
<h2>Set show row and column headers</h2>
<pre>setShowRowColHeaders(boolean $pValue) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pValue</h4>
<code>boolean</code><p>Show row and column headers (true/false)</p>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setShowSummaryBelow"></a><div class="element clickable method public method_setShowSummaryBelow" data-toggle="collapse" data-target=".method_setShowSummaryBelow .collapse">
<h2>Set show summary below</h2>
<pre>setShowSummaryBelow(boolean $pValue) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pValue</h4>
<code>boolean</code><p>Show summary below (true/false)</p>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setShowSummaryRight"></a><div class="element clickable method public method_setShowSummaryRight" data-toggle="collapse" data-target=".method_setShowSummaryRight .collapse">
<h2>Set show summary right</h2>
<pre>setShowSummaryRight(boolean $pValue) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pValue</h4>
<code>boolean</code><p>Show summary right (true/false)</p>
</div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_setTitle"></a><div class="element clickable method public method_setTitle" data-toggle="collapse" data-target=".method_setTitle .collapse">
<h2>Set title</h2>
<pre>setTitle(string $pValue, string $updateFormulaCellReferences) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pValue</h4>
<code>string</code><p>String containing the dimension of this worksheet</p></div>
<div class="subelement argument">
<h4>$updateFormulaCellReferences</h4>
<code>string</code><p>boolean Flag indicating whether cell references in formulae should
       	be updated to reflect the new sheet name.
         This should be left as the default true, unless you are
         certain that no formula cells on any worksheet contain
         references to this worksheet</p></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_shrinkRangeToFit"></a><div class="element clickable method public method_shrinkRangeToFit" data-toggle="collapse" data-target=".method_shrinkRangeToFit .collapse">
<h2>Accepts a range, returning it as a range that falls within the current highest row and column of the worksheet</h2>
<pre>shrinkRangeToFit(string $range) : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$range</h4>
<code>string</code>
</div>
<h3>Returns</h3>
<div class="subelement response">
<code>string</code>Adjusted range value</div>
</div></div>
</div>
<a id="method_sortCellCollection"></a><div class="element clickable method public method_sortCellCollection" data-toggle="collapse" data-target=".method_sortCellCollection .collapse">
<h2>Sort collection of cells</h2>
<pre>sortCellCollection() : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_toArray"></a><div class="element clickable method public method_toArray" data-toggle="collapse" data-target=".method_toArray .collapse">
<h2>Create array from worksheet</h2>
<pre>toArray(mixed $nullValue, boolean $calculateFormulas, boolean $formatData, boolean $returnCellRef) : array</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$nullValue</h4>
<code>mixed</code><p>Value returned in the array entry if a cell doesn't exist</p>
</div>
<div class="subelement argument">
<h4>$calculateFormulas</h4>
<code>boolean</code><p>Should formulas be calculated?</p>
</div>
<div class="subelement argument">
<h4>$formatData</h4>
<code>boolean</code><p>Should formatting be applied to cell values?</p>
</div>
<div class="subelement argument">
<h4>$returnCellRef</h4>
<code>boolean</code><p>False - Return a simple array of rows and columns indexed by number counting from zero
                              True - Return rows and columns indexed by their actual row and column IDs</p>
</div>
<h3>Returns</h3>
<div class="subelement response"><code>array</code></div>
</div></div>
</div>
<a id="method_unfreezePane"></a><div class="element clickable method public method_unfreezePane" data-toggle="collapse" data-target=".method_unfreezePane .collapse">
<h2>Unfreeze Pane</h2>
<pre>unfreezePane() : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_unmergeCells"></a><div class="element clickable method public method_unmergeCells" data-toggle="collapse" data-target=".method_unmergeCells .collapse">
<h2>Remove merge on a cell range</h2>
<pre>unmergeCells(string $pRange) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pRange</h4>
<code>string</code><p>Cell range (e.g. A1:E1)</p>
</div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_unmergeCellsByColumnAndRow"></a><div class="element clickable method public method_unmergeCellsByColumnAndRow" data-toggle="collapse" data-target=".method_unmergeCellsByColumnAndRow .collapse">
<h2>Remove merge on a cell range by using numeric cell coordinates</h2>
<pre>unmergeCellsByColumnAndRow(int $pColumn1, int $pRow1, int $pColumn2, int $pRow2) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pColumn1</h4>
<code>int</code><p>Numeric column coordinate of the first cell</p></div>
<div class="subelement argument">
<h4>$pRow1</h4>
<code>int</code><p>Numeric row coordinate of the first cell</p></div>
<div class="subelement argument">
<h4>$pColumn2</h4>
<code>int</code><p>Numeric column coordinate of the last cell</p></div>
<div class="subelement argument">
<h4>$pRow2</h4>
<code>int</code><p>Numeric row coordinate of the last cell</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_unprotectCells"></a><div class="element clickable method public method_unprotectCells" data-toggle="collapse" data-target=".method_unprotectCells .collapse">
<h2>Remove protection on a cell range</h2>
<pre>unprotectCells(string $pRange) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pRange</h4>
<code>string</code><p>Cell (e.g. A1) or cell range (e.g. A1:E1)</p>
</div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method_unprotectCellsByColumnAndRow"></a><div class="element clickable method public method_unprotectCellsByColumnAndRow" data-toggle="collapse" data-target=".method_unprotectCellsByColumnAndRow .collapse">
<h2>Remove protection on a cell range by using numeric cell coordinates</h2>
<pre>unprotectCellsByColumnAndRow(int $pColumn1, int $pRow1, int $pColumn2, int $pRow2, string $pPassword, boolean $pAlreadyHashed) : <a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pColumn1</h4>
<code>int</code><p>Numeric column coordinate of the first cell</p></div>
<div class="subelement argument">
<h4>$pRow1</h4>
<code>int</code><p>Numeric row coordinate of the first cell</p></div>
<div class="subelement argument">
<h4>$pColumn2</h4>
<code>int</code><p>Numeric column coordinate of the last cell</p></div>
<div class="subelement argument">
<h4>$pRow2</h4>
<code>int</code><p>Numeric row coordinate of the last cell</p></div>
<div class="subelement argument">
<h4>$pPassword</h4>
<code>string</code><p>Password to unlock the protection</p></div>
<div class="subelement argument">
<h4>$pAlreadyHashed</h4>
<code>boolean</code><p>If the password has already been hashed, set this to true</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response"><code><a href="../classes/PHPExcel_Worksheet.html">\PHPExcel_Worksheet</a></code></div>
</div></div>
</div>
<a id="method__checkSheetCodeName"></a><div class="element clickable method private method__checkSheetCodeName" data-toggle="collapse" data-target=".method__checkSheetCodeName .collapse">
<h2>Check sheet code name for valid Excel syntax</h2>
<pre>_checkSheetCodeName(string $pValue) : string</pre>
<div class="labels"><span class="label">Static</span></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pValue</h4>
<code>string</code><p>The string to check</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="http://php.net/manual/en/class.exception.php">\Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response">
<code>string</code>The valid string</div>
</div></div>
</div>
<a id="method__checkSheetTitle"></a><div class="element clickable method private method__checkSheetTitle" data-toggle="collapse" data-target=".method__checkSheetTitle .collapse">
<h2>Check sheet title for valid Excel syntax</h2>
<pre>_checkSheetTitle(string $pValue) : string</pre>
<div class="labels"><span class="label">Static</span></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pValue</h4>
<code>string</code><p>The string to check</p></div>
<h3>Exceptions</h3>
<table class="table table-bordered"><tr>
<th><code><a href="../classes/PHPExcel_Exception.html">\PHPExcel_Exception</a></code></th>
<td></td>
</tr></table>
<h3>Returns</h3>
<div class="subelement response">
<code>string</code>The valid string</div>
</div></div>
</div>
<a id="method__createNewCell"></a><div class="element clickable method private method__createNewCell" data-toggle="collapse" data-target=".method__createNewCell .collapse">
<h2>Create a new cell at the specified coordinate</h2>
<pre>_createNewCell(string $pCoordinate) : <a href="../classes/PHPExcel_Cell.html">\PHPExcel_Cell</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<div class="long_description"></div>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$pCoordinate</h4>
<code>string</code><p>Coordinate of the cell</p></div>
<h3>Returns</h3>
<div class="subelement response">
<code><a href="../classes/PHPExcel_Cell.html">\PHPExcel_Cell</a></code>Cell that was created</div>
</div></div>
</div>
<h3>
<i class="icon-custom icon-property"></i> Properties</h3>
<a id="property__activeCell"> </a><div class="element clickable property private property__activeCell" data-toggle="collapse" data-target=".property__activeCell .collapse">
<h2></h2>
<pre>$_activeCell : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"><p>(Only one!)</p></div></div></div>
</div>
<a id="property__autoFilter"> </a><div class="element clickable property private property__autoFilter" data-toggle="collapse" data-target=".property__autoFilter .collapse">
<h2></h2>
<pre>$_autoFilter : <a href="../classes/PHPExcel_Worksheet_AutoFilter.html">\PHPExcel_Worksheet_AutoFilter</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__breaks"> </a><div class="element clickable property private property__breaks" data-toggle="collapse" data-target=".property__breaks .collapse">
<h2></h2>
<pre>$_breaks : array</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__cachedHighestColumn"> </a><div class="element clickable property private property__cachedHighestColumn" data-toggle="collapse" data-target=".property__cachedHighestColumn .collapse">
<h2></h2>
<pre>$_cachedHighestColumn : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__cachedHighestRow"> </a><div class="element clickable property private property__cachedHighestRow" data-toggle="collapse" data-target=".property__cachedHighestRow .collapse">
<h2></h2>
<pre>$_cachedHighestRow : int</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__cellCollection"> </a><div class="element clickable property private property__cellCollection" data-toggle="collapse" data-target=".property__cellCollection .collapse">
<h2></h2>
<pre>$_cellCollection : \PHPExcel_CachedObjectStorage_xxx</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__cellCollectionIsSorted"> </a><div class="element clickable property private property__cellCollectionIsSorted" data-toggle="collapse" data-target=".property__cellCollectionIsSorted .collapse">
<h2></h2>
<pre>$_cellCollectionIsSorted : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__chartCollection"> </a><div class="element clickable property private property__chartCollection" data-toggle="collapse" data-target=".property__chartCollection .collapse">
<h2></h2>
<pre>$_chartCollection : <a href="PHPExcel.Chart.html#%5CPHPExcel_Chart">\PHPExcel_Chart[]</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__codeName"> </a><div class="element clickable property private property__codeName" data-toggle="collapse" data-target=".property__codeName .collapse">
<h2></h2>
<pre>$_codeName : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__columnDimensions"> </a><div class="element clickable property private property__columnDimensions" data-toggle="collapse" data-target=".property__columnDimensions .collapse">
<h2></h2>
<pre>$_columnDimensions : <a href="PHPExcel.Worksheet.ColumnDimension.html#%5CPHPExcel_Worksheet_ColumnDimension">\PHPExcel_Worksheet_ColumnDimension[]</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__comments"> </a><div class="element clickable property private property__comments" data-toggle="collapse" data-target=".property__comments .collapse">
<h2></h2>
<pre>$_comments : <a href="PHPExcel.Comment.html#%5CPHPExcel_Comment">\PHPExcel_Comment[]</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__conditionalStylesCollection"> </a><div class="element clickable property private property__conditionalStylesCollection" data-toggle="collapse" data-target=".property__conditionalStylesCollection .collapse">
<h2></h2>
<pre>$_conditionalStylesCollection : array</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"><p>Indexed by cell coordinate, e.g. 'A1'</p></div></div></div>
</div>
<a id="property__dataValidationCollection"> </a><div class="element clickable property private property__dataValidationCollection" data-toggle="collapse" data-target=".property__dataValidationCollection .collapse">
<h2></h2>
<pre>$_dataValidationCollection : array</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"><p>Indexed by cell coordinate, e.g. 'A1'</p></div></div></div>
</div>
<a id="property__defaultColumnDimension"> </a><div class="element clickable property private property__defaultColumnDimension" data-toggle="collapse" data-target=".property__defaultColumnDimension .collapse">
<h2></h2>
<pre>$_defaultColumnDimension : <a href="../classes/PHPExcel_Worksheet_ColumnDimension.html">\PHPExcel_Worksheet_ColumnDimension</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__defaultRowDimension"> </a><div class="element clickable property private property__defaultRowDimension" data-toggle="collapse" data-target=".property__defaultRowDimension .collapse">
<h2></h2>
<pre>$_defaultRowDimension : <a href="../classes/PHPExcel_Worksheet_RowDimension.html">\PHPExcel_Worksheet_RowDimension</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__dirty"> </a><div class="element clickable property private property__dirty" data-toggle="collapse" data-target=".property__dirty .collapse">
<h2></h2>
<pre>$_dirty : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__drawingCollection"> </a><div class="element clickable property private property__drawingCollection" data-toggle="collapse" data-target=".property__drawingCollection .collapse">
<h2></h2>
<pre>$_drawingCollection : <a href="PHPExcel.Worksheet.BaseDrawing.html#%5CPHPExcel_Worksheet_BaseDrawing">\PHPExcel_Worksheet_BaseDrawing[]</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__freezePane"> </a><div class="element clickable property private property__freezePane" data-toggle="collapse" data-target=".property__freezePane .collapse">
<h2></h2>
<pre>$_freezePane : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__hash"> </a><div class="element clickable property private property__hash" data-toggle="collapse" data-target=".property__hash .collapse">
<h2></h2>
<pre>$_hash : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__headerFooter"> </a><div class="element clickable property private property__headerFooter" data-toggle="collapse" data-target=".property__headerFooter .collapse">
<h2></h2>
<pre>$_headerFooter : <a href="../classes/PHPExcel_Worksheet_HeaderFooter.html">\PHPExcel_Worksheet_HeaderFooter</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__hyperlinkCollection"> </a><div class="element clickable property private property__hyperlinkCollection" data-toggle="collapse" data-target=".property__hyperlinkCollection .collapse">
<h2></h2>
<pre>$_hyperlinkCollection : array</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"><p>Indexed by cell coordinate, e.g. 'A1'</p></div></div></div>
</div>
<a id="property__invalidCharacters"> </a><div class="element clickable property private property__invalidCharacters" data-toggle="collapse" data-target=".property__invalidCharacters .collapse">
<h2></h2>
<pre>$_invalidCharacters : array</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__mergeCells"> </a><div class="element clickable property private property__mergeCells" data-toggle="collapse" data-target=".property__mergeCells .collapse">
<h2></h2>
<pre>$_mergeCells : array</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__pageMargins"> </a><div class="element clickable property private property__pageMargins" data-toggle="collapse" data-target=".property__pageMargins .collapse">
<h2></h2>
<pre>$_pageMargins : <a href="../classes/PHPExcel_Worksheet_PageMargins.html">\PHPExcel_Worksheet_PageMargins</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__pageSetup"> </a><div class="element clickable property private property__pageSetup" data-toggle="collapse" data-target=".property__pageSetup .collapse">
<h2></h2>
<pre>$_pageSetup : <a href="../classes/PHPExcel_Worksheet_PageSetup.html">\PHPExcel_Worksheet_PageSetup</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__parent"> </a><div class="element clickable property private property__parent" data-toggle="collapse" data-target=".property__parent .collapse">
<h2></h2>
<pre>$_parent : <a href="../classes/PHPExcel.html">\PHPExcel</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__printGridlines"> </a><div class="element clickable property private property__printGridlines" data-toggle="collapse" data-target=".property__printGridlines .collapse">
<h2></h2>
<pre>$_printGridlines : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__protectedCells"> </a><div class="element clickable property private property__protectedCells" data-toggle="collapse" data-target=".property__protectedCells .collapse">
<h2></h2>
<pre>$_protectedCells : array</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__protection"> </a><div class="element clickable property private property__protection" data-toggle="collapse" data-target=".property__protection .collapse">
<h2></h2>
<pre>$_protection : <a href="../classes/PHPExcel_Worksheet_Protection.html">\PHPExcel_Worksheet_Protection</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__rightToLeft"> </a><div class="element clickable property private property__rightToLeft" data-toggle="collapse" data-target=".property__rightToLeft .collapse">
<h2></h2>
<pre>$_rightToLeft : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__rowDimensions"> </a><div class="element clickable property private property__rowDimensions" data-toggle="collapse" data-target=".property__rowDimensions .collapse">
<h2></h2>
<pre>$_rowDimensions : <a href="PHPExcel.Worksheet.RowDimension.html#%5CPHPExcel_Worksheet_RowDimension">\PHPExcel_Worksheet_RowDimension[]</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__selectedCells"> </a><div class="element clickable property private property__selectedCells" data-toggle="collapse" data-target=".property__selectedCells .collapse">
<h2></h2>
<pre>$_selectedCells : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__sheetState"> </a><div class="element clickable property private property__sheetState" data-toggle="collapse" data-target=".property__sheetState .collapse">
<h2></h2>
<pre>$_sheetState : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__sheetView"> </a><div class="element clickable property private property__sheetView" data-toggle="collapse" data-target=".property__sheetView .collapse">
<h2></h2>
<pre>$_sheetView : <a href="../classes/PHPExcel_Worksheet_SheetView.html">\PHPExcel_Worksheet_SheetView</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__showGridlines"> </a><div class="element clickable property private property__showGridlines" data-toggle="collapse" data-target=".property__showGridlines .collapse">
<h2></h2>
<pre>$_showGridlines : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__showRowColHeaders"> </a><div class="element clickable property private property__showRowColHeaders" data-toggle="collapse" data-target=".property__showRowColHeaders .collapse">
<h2></h2>
<pre>$_showRowColHeaders : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__showSummaryBelow"> </a><div class="element clickable property private property__showSummaryBelow" data-toggle="collapse" data-target=".property__showSummaryBelow .collapse">
<h2></h2>
<pre>$_showSummaryBelow : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__showSummaryRight"> </a><div class="element clickable property private property__showSummaryRight" data-toggle="collapse" data-target=".property__showSummaryRight .collapse">
<h2></h2>
<pre>$_showSummaryRight : boolean</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__styles"> </a><div class="element clickable property private property__styles" data-toggle="collapse" data-target=".property__styles .collapse">
<h2></h2>
<pre>$_styles : <a href="PHPExcel.Style.html#%5CPHPExcel_Style">\PHPExcel_Style[]</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__tabColor"> </a><div class="element clickable property private property__tabColor" data-toggle="collapse" data-target=".property__tabColor .collapse">
<h2></h2>
<pre>$_tabColor : <a href="../classes/PHPExcel_Style_Color.html">\PHPExcel_Style_Color</a></pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="property__title"> </a><div class="element clickable property private property__title" data-toggle="collapse" data-target=".property__title .collapse">
<h2></h2>
<pre>$_title : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<h3>
<i class="icon-custom icon-constant"></i> Constants</h3>
<a id="constant_BREAK_COLUMN"> </a><div class="element clickable constant  constant_BREAK_COLUMN" data-toggle="collapse" data-target=".constant_BREAK_COLUMN .collapse">
<h2>BREAK_COLUMN</h2>
<pre>BREAK_COLUMN </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="constant_BREAK_NONE"> </a><div class="element clickable constant  constant_BREAK_NONE" data-toggle="collapse" data-target=".constant_BREAK_NONE .collapse">
<h2>BREAK_NONE</h2>
<pre>BREAK_NONE </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="constant_BREAK_ROW"> </a><div class="element clickable constant  constant_BREAK_ROW" data-toggle="collapse" data-target=".constant_BREAK_ROW .collapse">
<h2>BREAK_ROW</h2>
<pre>BREAK_ROW </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="constant_SHEETSTATE_HIDDEN"> </a><div class="element clickable constant  constant_SHEETSTATE_HIDDEN" data-toggle="collapse" data-target=".constant_SHEETSTATE_HIDDEN .collapse">
<h2>SHEETSTATE_HIDDEN</h2>
<pre>SHEETSTATE_HIDDEN </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="constant_SHEETSTATE_VERYHIDDEN"> </a><div class="element clickable constant  constant_SHEETSTATE_VERYHIDDEN" data-toggle="collapse" data-target=".constant_SHEETSTATE_VERYHIDDEN .collapse">
<h2>SHEETSTATE_VERYHIDDEN</h2>
<pre>SHEETSTATE_VERYHIDDEN </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
<a id="constant_SHEETSTATE_VISIBLE"> </a><div class="element clickable constant  constant_SHEETSTATE_VISIBLE" data-toggle="collapse" data-target=".constant_SHEETSTATE_VISIBLE .collapse">
<h2>SHEETSTATE_VISIBLE</h2>
<pre>SHEETSTATE_VISIBLE </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><div class="long_description"></div></div></div>
</div>
</div>
</div>
</div>
</div>
<div class="row"><footer class="span12">
            Template is built using <a href="http://twitter.github.com/bootstrap/">Twitter Bootstrap 2</a> and icons provided by <a href="http://glyphicons.com/">Glyphicons</a>.<br>
            Documentation is powered by <a href="http://www.phpdoc.org/">phpDocumentor 2.0.0a12</a> and<br>
            generated on 2014-03-02T15:27:39Z.<br></footer></div>
</div>
</body>
</html>
